The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
75 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |