This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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?
Go to the Format Visual -> X Axis settings ->disable Concatenate labels
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?
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 30 | |
| 24 | |
| 23 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 61 | |
| 35 | |
| 29 | |
| 23 | |
| 22 |