Forum Discussion
Change Numeric Range to Text Output
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:
1 Reply
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
