Forum Discussion

newpbiuser01's avatar
newpbiuser01
Icon for Helper V rankHelper V
3 years ago
Solved

Concatenate Labels on Horizontal Bar Chart

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!

 

  • 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.

1 Reply

  • 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.