Forum Discussion

AlejandroSaBa's avatar
AlejandroSaBa
New Member
2 years ago

Grouping Clustered Column Chart

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!

1 Reply