Concatenate Labels on Horizontal Bar Chart

[newpbiuser01]

Hello,

I'm trying to create a horizontal bar chart visual for a report with a hierarchical axis - Year/Quarter/Month. When I create a vertical bar chart, I see the "Concatenate Labels" option under the X axis and I am able to turn it off to get a visual that clearly shows the hierarchy. However, when I flip it to the horizontal clustered bar chart, there is no option to toggle the concatenate labels option. Would anyone know how I can create the hierarchical axis on a horizontal bar chart? 

 

Options for vertical bar chart

Options for horizontal bar chart:

Thank you!

[MFelix · Accepted solution]

Hi @newpbiuser01 ,

For the horizontal bar this option is not available, one work around can be to create a matrix and add the condittional formatting with bars that will simulate the chart, only option that will not be available is the x-axis values but you can show the values of the bars in each one has labels.