Hello all,
In a report I am working on I came across an issue that I am unable to solve with the options given in my Power BI version (this being 2.106.582.0 64-bit (June 2022)), and I was wondering if you know a way to do it.
I am trying to do a Clustered Column Chart that has three x axis level grouped, I want to have Category 1 then Subcategory then Month, all showed in the graphic (see Excel example).
But whenever I drill down to the month, the labels concatenate and show a really long label, even when the Concatenate option within the X-Axis options is turned off (see following example):
Is there any work around or way to obtain what I can obtain with a pivot chart in Excel?
Any help will be greatly appreciated. Thank you in advance!
@AlejandroSaBa if concatenate labels are off it shouldn't concatenate, here it is:
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Power BI Monthly Update - August 2025
Check out the August 2025 Power BI update to learn about new features.
Fabric Community Update - August 2025
Find out what's new and trending in the Fabric community.
