Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Labels shown when drilling down

Hello Community,

Consider the following table as a Hierarchy:

 

When I add the hierarchy to a visual and drill down it shows the full string of label values meaning if I drill down to the lowest level the label will read: "Car Audi A6".

 


In my data I have many levels and a lot of text in some of the labels which makes my visuals look cluttered.

Is there a way to make PBI visuals only show the label value of the currently 'selected' level so that drilling to the lowest level would just show: "A6" while still having drill-down enabled?

 

Need Help

2 Replies

  • SwayamSinha's avatar
    SwayamSinha
    Microsoft Employee
    3 years ago

    Go to the Format Visual -> X Axis settings ->disable Concatenate labels 

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you for your reply.

      I can find the setting the way you describe if I change my visual to a line chart like you have used.

      Can this also be achieved with a bar chart?