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.
Hi experts,
I need to show in report a single measure that is a number that should be green if positive, red - if negative. No titles, no other stuff, just plain number in different color. Power BI seems to be lacking this simple functionality.
Are there any tricks to go around this limitation?
The visual, that is most close to these requirements, to my mind, is Table visual. However Conditional formatting with Color by rules setting doesn't work on single number placed in a Table.
Solved! Go to Solution.
That's what I say too. Well, I managed to reach the result in a Table visual by setting white font for unnecessary rows.
Hi @gvg,
Currently, conditional color setting is not supported when you add a single measure to card visual. As a workaround, you can try the "Conditional Formatting" which is available in table visual. In below screenshot, [Min] is a measure.
Best regards,
Yuliana Gu
That's what I say too. Well, I managed to reach the result in a Table visual by setting white font for unnecessary rows.
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 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |