The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
I need to create a Stacked Bar Chart that uses values from four measures. The chart should look like this:
The four values you can see in the chart (24232, 9465, 4404 and 19481) are values calculated by 4 different measures. Is there a way to create such a stacked bar chart based on measures?
I tried to create this with calculation group but the result (see screenshot below) is not what I would like to have.
Frank
Solved! Go to Solution.
@FrankWe
To make it dynamically (on 1 chart) you would need calculated column in main table which sets if row is relevant for Vol or GM.
Then you would use that column as X axis and in values you would add all 4 measures and then enable labels and total labels.
If it can't be that dynamic, that i suggest creating 2 different visuals, one showing only Vol measures, another showing only GM values and then just rename X axis.
Remove titles from these two charts and add one text box centered above both of them as main title.
A little bit of work, but it will work.
Cheers,
Nemanja Andic
@FrankWe
To make it dynamically (on 1 chart) you would need calculated column in main table which sets if row is relevant for Vol or GM.
Then you would use that column as X axis and in values you would add all 4 measures and then enable labels and total labels.
If it can't be that dynamic, that i suggest creating 2 different visuals, one showing only Vol measures, another showing only GM values and then just rename X axis.
Remove titles from these two charts and add one text box centered above both of them as main title.
A little bit of work, but it will work.
Cheers,
Nemanja Andic