Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a bar chart and I want to switch the x-axis dynamically using a field parameter. However, I need the chart to display a specific level in the hierachy.
I clicked this button on the chart
and the data is displaying the way I want
but when I select the other field, the hierachy level is reset and I have to click the button to expand down again.
What I am expecting to see when I click name
Is there anyway to stop it from reseting the hierachy when switching columns?
@Anonymous , if you select one column, in the field parameter it will not show the hierarchy. For more than one selection or no selection it will show hierarchy and the order should same order they have been use in field parameter definition
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 134 | |
| 96 | |
| 78 | |
| 67 | |
| 65 |