Niels vdc on 16 Apr 2021 09:30:42
When you create a KPI field using Tabular Editor, you can add three expressions to the KPI: Status, Target & Trend. After creating the KPI, Power BI shows a maximum of 4 subfields for the KPI: Value, Goal, Status & Trend.
It would be great to have a new expression property that could be used to create a custom color output and results in the KPI field having a 5th subfield named Color.
The reason for this request is that I'm creating lots of KPI's for customers, that want to display the KPI's using a gauge visual. And by default the data color should be red, green or orange (bad, good or other). Now I always have to create a separate field that contains the color for the KPI.