Power BI - How to drill down without displaying each level being drilled down into for x axis

[Anonymous]

Hi,

Is there a way for me to drill down without each level being drilled down being added to the x axis of my bar graph? For example, right now if I drill down into "Fruits", it will display "Fruits, Apple", and "Fruits, Banana", but I just want it to say "Apple" and "Banana". For one of my dashboards it does this, but for my new dashboard, it shows "Fruits, Apple" etc. When I drill down 5 levels deep the x asis looks crazy with too much words. 

Thanks!

Alex

[Greg_Deckler]

@Anonymous - There is an option to turn off concatenation of labels in the axis. Also, there is the double arrow drill down that just takes you to the next level without regard for the previous level so not sure which of those you want.

[Anonymous]

Thank you for the reply. 

I want to use single drill down arrow though, as I have many categories (not just "fruits" for example). I tried using the concatenate labels in x-axis, but it doesn't seem to do anything for me. 

I noticed now, if I right click the bar graph and select "Show next level" that does what I want, but I would like that to work with drill down instead of right click then "Show next level" if possible

[v-xicai · Accepted solution]

Hi @Anonymous ,

You may click the Dirll mode icon, then click one point of Bar, after that , you may see the next level like Picture2, then  go to Format section, turn on the option "Concatenate labels" under X axis tab.

Best Regards,

Amy 

Community Support Team _ Amy

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