CODEWITHSUNDEEP
powerbidax
jcoke
jcoke

Reputation: 1891

Display sum of values and group by another column within a column chart in Power Bi

Lets say I have this table for instance, which shows the values and what colour it is for July 1st 2020:

enter image description here

Currently the column chart looks like so:

enter image description here

Is there a way to sum up val and group by the RAG column and represent this as a column chart?

So it will still show one chart but it will segment it into how much of that total was in the red zone, how much was in the amber zone and how much was in the green zone.

Note: I have tried adding RAG on the axis but this splits the chart rather I need them to be in one bar but showing the split between each RAG

enter image description here

Upvotes: 0

Views: 1037

Answers (1)

Ryan B.
Ryan B.

Reputation: 3665

Try using the Stacked Bar Chart visual and put RAG in as the legend.

Upvotes: 1

Related Questions