Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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 "Fru...
  • v-xicai's avatar
    v-xicai
    6 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

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.