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
Anonymous,
Using conditional formatting feature in Power BI Desktop, you can achieve your requirement. Please review the following screenshots.
Regards,
Lydia
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.