Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Howdy,
I have needed to change the colour of the field value in a CARD, which I know cannot be done at the moment. I downloaded the vizualisation 'Advance Card' which enables this to be done. Had it working and published, on the browser works perfectly. As I change filters, it changes from red to green as expected.
Now, when I download the PBIX file, and I select the field in Power BI Desktop, the highlighted vizualisation is the Card. I have the Advance Card installed and can see it on the list, but the field when selected highlights the Card icon. Also, when I look at Visual / Callout Value for the card under Color it just has the dropdown option for colour, and is defaulted to red (as default filter sets it to red). When I change the filter in Desktop, the colour changes to green as expected. Change again, goes back to red.
The minute I click on the color dropdown box, when I change the filter it now does not change.....
Can someone explain what I am doing wrong?? Is ADvance Card the only 'easy' way to change the colour of a value??
Thanks
Nick
Solved! Go to Solution.
You can achieve this with the native Card visual by using the measure below (use color codes or names):
Color Format =
VAR vAmount = [Amount]
VAR vResult =
SWITCH (
TRUE,
vAmount > 0, "Green",
vAmount = 0, "Yellow",
vAmount < 0, "Red"
)
RETURN
vResult
In the Card formatting options, set conditional formatting:
Result:
---
---
Proud to be a Super User!
You can achieve this with the native Card visual by using the measure below (use color codes or names):
Color Format =
VAR vAmount = [Amount]
VAR vResult =
SWITCH (
TRUE,
vAmount > 0, "Green",
vAmount = 0, "Yellow",
vAmount < 0, "Red"
)
RETURN
vResult
In the Card formatting options, set conditional formatting:
Result:
---
---
Proud to be a Super User!
User | Count |
---|---|
141 | |
70 | |
69 | |
52 | |
52 |
User | Count |
---|---|
209 | |
92 | |
64 | |
60 | |
57 |