cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lano_99
Regular Visitor

Dynamic axis based on hierarchical slicer

Hi,

 

I have a 3 level hierarchy in my data model with country, state and city. I put that hierarchy in a slicer, and as an x-axis in a bar chart.

 

However, I would like the bar chart axis to automatically adapt to the user's selection. For example, if the user select a country, then I would like to show states in the bar chart automatically without him having to drill-down. If he choose a state in the slicer, then I would like to show cities as bar chart axis.

 

Is there a solution to this problem?

 

Thanks you

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@Lano_99 , As of now that is not feasible, what is you filtering that will become axis or next level become axis

 

But You can try the field parameter for the Dynamic axis

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...



Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Learn Power BI P&L Statement || Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s ||
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!!! How to get Quick Help !!
Resources | Master Power BI !! Expertise Power BI !! Power BI For Tableau User !!

View solution in original post

v-yueyunzh-msft
Community Support
Community Support

Hi , @Lano_99 

At the moment we don't have a way to automatically drill through the values selected by the slicer, but you can try the new feature to switch the dimensions of the visual.

For how to use the "Field Parameter", you can refer to these ducuments:

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Field Parameters in Power BI - Microsoft Power BI Community

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

View solution in original post

4 REPLIES 4
v-yueyunzh-msft
Community Support
Community Support

Hi , @Lano_99 

At the moment we don't have a way to automatically drill through the values selected by the slicer, but you can try the new feature to switch the dimensions of the visual.

For how to use the "Field Parameter", you can refer to these ducuments:

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Field Parameters in Power BI - Microsoft Power BI Community

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

Field parameters were a good alternative, thank you!

amitchandak
Super User
Super User

@Lano_99 , As of now that is not feasible, what is you filtering that will become axis or next level become axis

 

But You can try the field parameter for the Dynamic axis

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...



Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Learn Power BI P&L Statement || Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s ||
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!!! How to get Quick Help !!
Resources | Master Power BI !! Expertise Power BI !! Power BI For Tableau User !!

Even if it doesn't completely meet my needs, field parameters were a good alternative. Thank you! 

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.