Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
ksimpson50502
Frequent Visitor

How To Disable Inline Hierarchy

Hello, it seems that since I have recently updated to the September 2022 version of Power BI Desktop, inline hierarchy has become the default and I do not know how to turn it off. I found a microsoft article, that says sometimes you can get stuck in inline hierarchy, and it says to disable it...but it doesn't tell me how. https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-inline-hierarchy-labels#how-inline...

 

This makes my bar charts extremely difficult to read for users. I saw some old posts that said to try converting it from a bar chart to a column chart and turning off concatenate, which I tried but that didn't work. Concatenate wasn't even selected on. Does anyone know how to Disable Inline Hierarchy?

 

ksimpson50502_0-1665377262395.png

You can see in this visual I have 3 levels in this hierarchy: State - City State - Store number. It showing all 3 levels at once and I don't need all that info. This visual is not as hard to read as some of the other bar charts that have really long names and go down several more levels...

1 ACCEPTED SOLUTION

Yes, Concatenate labels option is not working for bar chart.

View solution in original post

5 REPLIES 5
v-yadongf-msft
Community Support
Community Support

Hi @ksimpson50502 ,

 

Please create a stacked column chart instead of a stacked bar chart.

vyadongfmsft_0-1665470885003.png

 

Turn off Concatenate labels option.

vyadongfmsft_1-1665470989083.png

Best regards,

Yadong Fang

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

I need a bar chart not a stacked column. Is that not an option?

Yes, Concatenate labels option is not working for bar chart.

amitchandak
Super User
Super User

@ksimpson50502 , Set Concatenate label - On and try.

 

But this is now by default. Refer for More Details

https://powerbi.microsoft.com/en-us/blog/power-bi-september-2022-feature-summary/#post-20773-_Toc113...

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

I understand I need to change the setting, but HOW? If it is the new default, I didn't make any changes to turn it on. Concatenate is not a Y Axis Option

 

ksimpson50502_0-1665412728535.png

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.