Forum Discussion
Bar Graph - 2 Different Categories
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
Hi Kmcdonald ,
Here, is a 100 % Stacked Clustered Column Chart where you can put two different values (e.g: Open and Close) and also add category on legend for the stacks. You can change 100% to only stacked columns by selecting - under visual attributes > Bar Chart > All > From (None, Percent, Fraction) select None. Hope this helps you.
100 % Stacked Clustered Column Chart. pbivizedit.com
Download link for the custom visual file on this page,
https://pbivizedit.com/gallery/100stacked-clustered-column-chart
This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,
- anyone, irrespective of technical skills, can create their visuals
- 15 minutes to create a visual from scratch
- opens up many additional attributes to edit (e.g. labels, tooltips, legends position, etc)
Give this a shot and let us know if you face any problems/errors.
You can use the editor to modify your visual further (some modifications cannot be done in the Power BI window and have to be in the editor).
Thanks,
Team PBIVizEdit