Forum Discussion
Stacked Bar Chart with Two Different Measures
Good Afternoon,
Please see screenshots below, I would like to create a stacked bar chart where there are two bars, one showing "Total Actual" & the other showing "Baseline" (see screenshot 1), each bar is split by Header Item Type (See screenshot 2).
I have attached a third screeshot which shows how it would look except instead of the labour categories it would be the two measures mentioned above.
Thanks in advance for any help!
Screenshot 1:
Screenshot 2:
Screenshot 3:
3 Replies
- amitchandak
Super User
Anonymous , Not very clear. Do you need clustered stacked bar
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001934?tab=overview
Hi amitchandak ,
Thanks for your fast response.
I would like to show a stacked bar chart as shown in my screenshots, the "Header Item Type" as the legend (the different shades on the bar) but showing two bars, one for "Actual" & the other for "Baseline"
V-lianl-msftCommunity Support
Hi Anonymous ,
According to my test, at this stage, we can't add two measures to Stacked Bar Chart visual with legend field.
At the same time, we can't do conditional formatting the visual.
There is a way to switch measure to see if it can be an alternative.:
https://www.linkedin.com/pulse/powerbi-stacked-column-chart-using-only-measures-giuseppe-piluso
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
