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 "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

  • 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.

     

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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'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.