Forum Discussion
Conditional color formatting - overview
Anonymous,
Using conditional formatting feature in Power BI Desktop, you can achieve your requirement. Please review the following screenshots.
Regards,
Lydia
So, the KPI visual has a Target Goals section in the Fields area. Often, you use an Enter Data query to just create your goals in a wide, single row table and just drag the appropriate column into the field. Or, just create a goal measure like:
My Goal = 37
And use that. You will need something in the Trend Axis field, use any column. If you really do not want any trend axis displayed, create a column like:
My Column = 0
And put that in your Trend Axis.
Note that coditional formatting is available in Tables and Matrix visualizations as well. You can click on the little down arrow for a column or measure in the Fields area and choose "Conditional formatting" if it is a numeric field.
Thanks for the feedback!
So it doesn't look like there is conditional formatting in KPI',s correct?
Z
KPI by default shows green above a certain value and red below that value. Neutral is Yellow by default. You can change the default settings by using the Format area (paint roller icon) in the Visualizations pane under Color coding. You can change what is good and you can change your good, neutral and bad colors.
If you are talking about the Gauge visual from the other post, then it has different options in the Format area. Under Gauge axis, you can just type in your Max and your Target. You can change the colors under Data colors, etc.
Thanks but how can I change the range...like if I want it specifically 0-10% RED, 11%-50% black, 51%-100% green? I don't see anywhere to change the ranges for each color. Thanks.
Anonymous,
Using conditional formatting feature in Power BI Desktop, you can achieve your requirement. Please review the following screenshots.
Regards,
Lydia