KPI / Gauge indicator help please

Hi Anonymous,

Until now, we can not set the KPI or Gauge visualization color dynamically. The feature request has been submitted here. 

While, you can use the bar chart to display the value in different colors. I am not sure if it's what you expected. I create the following sample.



Then create the calculated columns using the formula.

sum of each clint = CALCULATE(SUM(Table1[Value]),ALLEXCEPT(Table1,Table1[ClientName]))

color = IF(Table1[sum of each clint]<250,"Green",IF(Table1[sum of each clint]<349,"Amber","Red"))

Finally, create a bar chart, set the bar color based on the color column. You can also create a slicer, when you select one client, the bar chart diaply the total value of the selected client in different color.



Please download the file, and check if it's helpful for you.

Best Regards,
Angelia