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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sidhartha_arima
Helper II
Helper II

How to set dynamic x-axis title in power bi while doing drill down?

By default, the graph is showing "Division" wise data and the a-axis title is "Division".On drill down, I am showing "Department" wise data. The expected x-axis title is "Department" but it's showing the "Division Department".How to fix this? 

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

Hi @sidhartha_arima ,

 

Please refer to this blog:

https://radacad.com/better-drill-down-experience-with-power-bi 

Howervr,only for "go to the next level in the hierachy" not the "Expand all down one level in the hierarchy".

 

Best Regards,
Liang
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

2 REPLIES 2
V-lianl-msft
Community Support
Community Support

Hi @sidhartha_arima ,

 

Please refer to this blog:

https://radacad.com/better-drill-down-experience-with-power-bi 

Howervr,only for "go to the next level in the hierachy" not the "Expand all down one level in the hierarchy".

 

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

amitchandak
Super User
Super User

@sidhartha_arima , If you right-click and drill or you use the parallel arrow you will get the only drill down the name. If you drill down using reverse Y means drill it last level with all level included (expand all), in that case, it shows state - city

 

Refer : https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.