This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
Hello friends,
I want a very simple KPI showing just one number being Red if below zero or Green - if above.
That's it.
I've tried KPI visual - and was supprised to find out that I cannot change the font size. Also it demands a time axis, which is irrelevant in my scenario (but this I've managed to overcome with measures). The font size is still a No-Go for me to use it.
I also tried a card visual - but no color rules there
I have tried both - a Table and a Matrix with conditional formatting. Neither work, because they consider my number to be a Total if I don't put anything on rows and the conditional formatting doesn't apply on Totals.
What am I missing? A very simple task and no visual for it?
Please help
Thank you!
Michael
@Anonymous
Try using Card With States Custom Visual.
Regards
Victor
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 14 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 47 | |
| 39 | |
| 24 | |
| 20 | |
| 20 |