3+ approaches for Dynamic Axis in Power BI

There are different approaches to having a dynamic axis in Power BI. Adam walks you thought 3 way to accomplish it within your Power BI report.


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

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

[viveksadashivaiah]

Didn’t know about the personalized views on Service!! I’m so looking forward to take our organization‘s reporting to the next level!! Thanks Adam 👍🏽

[rvweteling]

Hi Adam,
thanks for the options. I wanted to tackle this about a year back where people could switch between month or week on the axis. And this would reoccur on each page in the report. So I did something like option 2 but not exactly as I didn't need 'special' measures.
I created an expanded calendar-like table, where each date is in twice, looking something like below:
Date | View | Label
1-1-21 | Month | Jan
1-1-21 | Week | WK01
it had some other columns as well to identify if it was the previous month (or week), as I always wanted to show the last 6 months or weeks. I connected it to my regular calendar table. I put the Label on the x-axis, can slice on 'View' and all my data is connected to the regular date table and I can use measures without identifying what 'view' is selected (like: measure = IF(SELECTEDVALUE([View])="Month", xxxx, as this table will group and filter the results.
It was some work to set up the table, but then I could use this on the different pages (it's a big report) and with syncing slicers, all the pages have the same view. Afterwards even expanded it to switch between 'past 6 periods' and 'past 5 + current period' (duplicated lines again, and had different DateDif results so I can show DateDif 0-5 always).

[yelperalp]

Don't forget drill up + drill down!! Much easier...

[javiergonzales]

Wow. This is just what I was looking for. Didn't know about personalised visual or perspectives. Thanks for sharing with the community, Adam

[alexanderchernov]

Awesome 8 minutes in a cube. Just seen Personalized views for the first time.

[emmawith]

I use the first approach all the time, I find it works very well so long as I keep all my bookmarks clearly named and well-organised! Users seems to quickly understand how to navigate this set-up too.

[lukeminikoski]

All new features are incredible, but my end users just want tables and matrix to export to excel!

HAHAHAAH

[AnilKumar-ebhc]

Hello, I tried as per the process shared by you, but graph are not changing and show blank. Could you please help me.

[VladMZ]

This specific example with time dimension is a lot easier to solve with having all three levels in the axis and teach people how to drill down and up. Instead of messing with the perspectives.

[joshholt]

Can you make a video on how you would handle this for a dynamic hierarchy?

[peterhoogendoorn]

Nice options! Is there also a way to alter the Y-axis dynamically? In my bubble chart, the top and bottom bubbles always get cut off midway. My end-users complain about this so would love to see if there is also a way around that as well! Thanks in advance.

[davelaws]

On approach #1, if I had the whole report change would the button would that affect the performance of the report due to too many visuals?

[jennnlesly]

i am using the table switch method, but how can i sort the x-axis based on the time sequence? In you example, the Month is randomly sorted.
i have a Month list (Jan'24, Feb'24, Mar'24..) and Quarter list (Q1'24, Q2'24..., Q2'25...), how can this be sorted based on time sequence?

[alocalthreat]

Less than 10 seconds in and I'm already contemplating clicking on the next video because Adam said "axises" LOL! Just kidding guys, great vid.

[AJM]

I don't think I can get tabular editor with my work, is it essential for approach 3 and 3.1?

[noorjannah]

Hello!
can you please make a video about stock management for supply chain. How to keep freshness of stock by expiry date and also by batch?
Really appreciate your help!

[massimocolaceci]

Great! I didn't know options 3/3+

[mohammedsihadjmohand]

what if I need to do it on both Legend and X Axis? Swapping between Dimensions

[tawerwerroronoa]

hi.. it is possible in excel to dynamically select items to show in one chart and can also do multiple selection with the help of a little vba.. is it also possible in power bi? thanks in advance

[abcthegreat]

Is approach 3 available in the Report Server?