Change Numeric Range to Text Output

[asuhaimi]

Hello,

I would like to get below text ouput on my report (PIE Chart)

>90% - Excellent

70% to 90% - Good

50% to 70% - Average

Less 50% - Poor

From my column samples here.. How I'm gonna get formula in custom column?

expect result:

[MattAllington]

You should unpivot all the data columns so you get "attribute", "value". The attribute will be the current column names. Then add a conditional column using your rules. Load to power BI and use your new conditional column as the legend in the pie chart, and count of values in the values