Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Multi Level Category chart

Hi    I would like to know if you can create a Multi Level Graph, like I have enclosed.  I know how to create a Matrix with is great but would really like a graph.  Thanks in advance
Show and Tell
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Yes, you simply stack columns in your axis to create an adhoc hierarchy or use an actual hierarchy in your axis and you get drilldown arrows. Unfortunately, turning off "Concatenate labels" currently appears to be broken so the axis will not appear exactly as it is in your image. You can vote up the Issue in the Issues forum:

https://community.powerbi.com/t5/Issues/X-Axis-Concatenate-Labels-Clustered-Column-Chart-not-working/idi-p/1079632