Forum Discussion
Kmcdonald
Helper III
Helper IIIBar Graph - 2 Different Categories
Hi, I'm trying to replicate the below report, from Excel into BI so that I can have it refresh instead of manually adding data. This is what I have been able to do so far (not quite ...
Kmcdonald , the First option is to concatenate label off. Expand axis, sort on that concatenate label off
Concatenate Label off : https://youtu.be/QgI0vIGIOOk
Or you use small multiple for open and close https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-small-multiples
mussaenda
Community Champion
Community ChampionIf I understood you correctly,
You want to compare the Open and Close with the same x axis on the same graph.
With this,
You can put the Open Close Category on the axis and play with the heirarchy until you achieve what you need.
Hope this helps.
Thanks