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 ge...
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