Dynamic X and Y Axis in Power BI visuals? Yes please!

Have you wanted both dynamic X and Y axis within a Power BI visual? Patrick shows you how you can use Field Parameters to accomplish it!

Let report readers use field parameters to change visuals


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #DynamicAxis #GuyInACube

[robinabramson]

I used to 'specialize' in creating 'fully dynamic pages' prior to field parameters. This video gives me both joy and sorrow (but mostly joy). Love that it can be done so easily now.

[kishataylor]

I am so impressed. I watched a video for the last 1-2 hours and could not understand how to get this. The method was soooo complex. But your video, quick, simple to follow and I did it in like 60 seconds- Wow !!! Thank you soooo much. I will definitely search for your videos first, the next time. Keep up the amazing work.😊

[allisonkleeschulte]

LOVE LOVE LOVE this new feature! We are changing 90% of our reports to this because it's so scalable! We're doing this as matrix "levels". We make one field parameter with 10 different fields and then several others with just one field and copy the DAX (except for the name) from the first one and paste into the others instead of having to go through the GUI for all of them (much faster). Also you can create a none field by making a column in a small table (just for speed) with the name of NONE = blank () this way in a matrix the user doesn't have to have 5 levels if they don't want to. One more idea - we have divisions that all have their own "fields" - imagine one Division uses the field Color and another Division uses the field Size but we want one report that works for everybody. You can create cascading field parameters so that one slicer chooses what the others show as fields - SUPER DOOPER Dynamic :)

[Edu-qvyj]

A friend told me: when you don't know something, is not difficult to create, you only need know where to search. Awesome video.

[ryanfisher]

This and the dynamic visuals video you put together should be a required viewing for all Power BI report developers. An amazing feature and you've made it very understandable. Thank you.

[malgorzatamaciukiewicz]

Thank you. I am now migrating from SAP Analytics Cloud to PowerBI and this is very helpful. Dynamic axes are amazing and my colleagues love them.

[gabrielatanevska]

OMG have been waiting for this forever! Thank you!

[dineshgandhi]

Short and sweet! make all concepts in the same way man . Thanks to guyinacube .... Cheers

[johnfundibuzi]

Hi Patrick you guys are probably the best “go-to” channel for Power BI. thank you so much for all the hard work and for sharing !!!

[Tapzzzzz_]

You've explained such a big topic under 3 minutes ... Wow!!
Thank You so much

[zzota]

Instead of having different pages for 'Sales' or 'Quantity' I can have it all in one! I like that 🙂

[aleccobabe]

I'm missing the dropdown for New Parameter, so I can only build a numeric range parameter. Anyone know why this might be?
EDIT: Figured it out. Field parameters had to be enabled in Options.

[king_elk]

Great! Just in the right time to implement it into my first Power BI report which soon is going live in the company I work . Started working with Power BI only 3 weeks ago and your content already helped me a lot. Keep up the good work and thank you both for sharing your knowledge with us 🙂

[michamachowski]

Exactly what I was looking for!! <3 Thank you Patrick!

[noneB]

Using field parameters+ switch you can implement dynamic y-axis where you can group multiple measures in 1 category. Like total projects and target projects = projects category. Use that category as slicer to view 2x measures on y-axis at once without multiselecting.

[abbasm]

When I try this for the Y-Axis, it changed it from numeric values. So I no longer can choose to display the Y-Axis by count, sum, average, etc. I only can show by count and therefore get the value of 1 for everything. Can you please help?

[janoscahana]

I love this feature!!!! I implemented optional reports that used buttons and bookmarks to achieve something similar (I only managed to do it with one axis). This simplifies it to a couple clicks. Amazing improvement!

[rickb.]

We had a table that the data needed to be analyzed by multiple teams but it has over 800 columns of data. I used parameters and checked all the columns off and some others from other tables. Added other static columns in the front. Now users can use the table visual and see any columns they want by searching and selecting in the slicer. Then if you use the newer visual for search in the add visuals, change your parameter category to say address, now you can search the column headers as well by dragging in parameter to the search visual. Boom... So cool

[trisabiswas]

This is awesome!! 😍 I had no idea power bi even had this feature

[VictorOmark]

Woah !! You just have some matrix PowerBi moves. Thank you for sharing. This is awesome vid about new feature.