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 upgrading! Read all of the details including the timeline and what you can expect. Learn more
I have a measure displayed in a card visualization. The measure is ([Revenue January] / [Revenue December]) - 1 , displaying the %diff this month compared to previous month. Now, I would like this Card visual, or any other available custom visual, to be displayed in Green or Red font, depending on the value. A very easy thing to do in excel, but cant seem to find any decent solution in Power BI.
Anyone know how to solve this? Is there any custom visual out there that solves this problem?
Thanks
Solved! Go to Solution.
Try the Card with States Custom Visual I think you'll like it
I personally use it a lot and now with the latest release its even better!
However download it from here to make sure you have the latest version
http://okviz.com/card-with-states/
Good Luck! ![]()
Probaby not around when this was posted but there is a "Advance Card" in the marketplace that has some controlling over the colouring given specific conditions.
It seems to work pretty well so far.
You get to specify a Measure for the display and set a different measure for the condition.
So in my case iver used a UNICHAR character in the display, and the numerical value in the condition.
Means I display up arrows, down arrows or side arrows, and then can change the colours of those unichar characters very easily in the conditions section of the control.
Try the Card with States Custom Visual I think you'll like it
I personally use it a lot and now with the latest release its even better!
However download it from here to make sure you have the latest version
http://okviz.com/card-with-states/
Good Luck! ![]()
Instead of using the Card visual, use the KPI visual
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 |
|---|---|
| 45 | |
| 38 | |
| 24 | |
| 22 | |
| 20 |