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.
I have copied the matrix table from one report to another, then changed the source BUT the conditional Formatting is not working correctly
Required Greater Than 95% colour should be Green, less than 95% should be red (although Power BI does not do red very well)
First Matrix (New month February) does not continue Formatting
The second Matrix is wrong completely
Conditional Formating
Solved! Go to Solution.
Hi @Anonymous ,
Try defining your conditional formatting on a scale of 0 to 1 like Minimun=0, Maximum=0.95
Check if this works.
Thanks,
Pragati
Hi @Anonymous ,
Try defining your conditional formatting on a scale of 0 to 1 like Minimun=0, Maximum=0.95
Check if this works.
Thanks,
Pragati
Thanks for such a quick answer 0.95 did not work, gave the wrong results completly
BUT
9.5 as the higher works like a treat, thank you so much for the guidance and putting me on the right track
Hi @Anonymous ,
This could be due to the data formatting of your percentage field. But nice that you found the solution.
Thanks,
Pragati
How do I check the data formatting of the percentage field?
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |