Display sums of 3 columns in stacked columns chart

[vitoeee]

Hello,

Okay I'm a newbie on PowerBI and know nothing about measures with DAX functions yet 😄

So basically I got a table "Risks" which include the 3 following numeric columns:

- Pre response rating

- Current rating

- Post response rating

Depending on the rating, we will then define the criticality "Area of improvement (1-8)", "Area of concern (16)", "Issue (32)", "Major issue (64)", "Critical issue (128)", "Exceptional issue (256)".

I'd like to represent this as a stacked columns chart, with 3 columns "Pre response rating", "Current rating", "Post response rating" which would sum the total of each column, with the type of criticality as the legend.

I don't manage to put the 3 ratings as my Axis, any suggestions would be much appreciated!

Thanks!

[v-yulgu-msft]

Hi @vitoeee ,

Please illustrate your requirement with sample data and desired output.

How to Get Your Question Answered Quickly

Regards,

Yuliana Gu