Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I am try to conditionally format the background of my visuals based off of a measure then a scoring level of 0 (red), 5 (yellow) or 10 (green). I am having troubles conditionally formatting the background of my visuals that do not have data. In the Background>Color settings it has Default formatting options but only for blanks. When I view my visual as a table it is emplty so I believe that my data is not returning a blank and it is seen as a zero.
Any advice on this? I can give more info if needed. Thanks!
Background>Color>fx Settings
Empty Table
Solved! Go to Solution.
@mboomgaa , with Range I doubt, but with Measure color and use that in conditional formatting with field value option
Switch( true() ,
isblank([measure]) , "red" ,
[measure] =0 , "Yellow" ,
[measure] <10 , "Orange",
"green"
)
refer
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://www.youtube.com/watch?v=RqBb5eBf_I4
@mboomgaa , Create a measure
New measure = [measure] +0
And use this measure in coditional formatting
I think in that case if should pickup 0 .
0 can be an acceptable and scorable value from the measure so I want it to actually format the empty value as a blank like it indicates it will in the settings.
Hi @mboomgaa ,
Could you pls some sample data,or if possible ,your .pbix file would be better for us to test?
Remember to remove the confidential information.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
@mboomgaa , with Range I doubt, but with Measure color and use that in conditional formatting with field value option
Switch( true() ,
isblank([measure]) , "red" ,
[measure] =0 , "Yellow" ,
[measure] <10 , "Orange",
"green"
)
refer
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://www.youtube.com/watch?v=RqBb5eBf_I4
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |