Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Retain hierarchy level when using field parameter.

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 

frogmoney_0-1676599756606.png

 

and the data is displaying the way I want 

Screenshot 2023-02-16 211143.png

but when I select the other field, the hierachy level is reset and I have to click the button to expand down again. 

 

Screenshot 2023-02-16 211438.png


What I am expecting to see when I click name

Screenshot 2023-02-16 211707.png
Is there anyway to stop it from reseting the hierachy when switching columns?

1 REPLY 1
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.