Forum Discussion
Conditional color formatting - overview
- Anonymous8 years ago
Anonymous,
Using conditional formatting feature in Power BI Desktop, you can achieve your requirement. Please review the following screenshots.
Regards,
Lydia
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.
- Anonymous8 years agoNot applicable
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.
- Anonymous8 years agoNot applicable
Anonymous,
Using conditional formatting feature in Power BI Desktop, you can achieve your requirement. Please review the following screenshots.
Regards,
Lydia- Anonymous8 years agoNot applicable
I have the same issue, for gauges. I'm a novice, and cannot follow the instruction to "Review the following screen shots." I don't know what the screen shots are telling me to do. Believe me, I wich I did!. I need something like the following (I'm making some assumptions about what I THINK the scren shots are saying, but my confidence that I am correct is very low): "1-Highlight the visual you want to conditionally format. 2-Go into Data View. 3-Click "Modeling." 4-Click "New Column." Name it whatever you want. 5-... what do I do next? (if 1-4 are even correct).
I have 14 gauges on one page in a Desktop report. Each gauge is associated with a KPI. The arc in the gauge gets filled with the Actual result for the period (such as month or quarter), and a target is shown by a line going across the arc at the appropriate place. I want to fill the arc with Green, Yellow or Red depending on the result against the target, and depending on the Year and Month a User slects from slicers. A twist is that the target might be different from period to period (for example, the target might be set per month, rising each month to the year-end number in December).
Is this possible? As I said, I'm a novice, but I need to deliver this. I don't know DAX, so I need the specific code, where to put it, step-by step. I realize this is a lot to ask, but if anyone is willing to help, I will certainly appreciate it.
- Anonymous8 years agoNot applicable
This is exactly what I want but I do not see this selection for KPIs. What visualization are you using?
Thanks for the help,
Z
- Greg_Deckler8 years agoCommunity Champion
That is a Table visualization.