Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hi All
Recently @VijayP intro me advance card , i have manage to display YTD sales with Growth % with the help from @v-robertq-msft , now working fine .
Now i need to make the Vari % change red color when -ve value.
Above link is my PBI
Paul
Paul
Solved! Go to Solution.
Hi Paul,
That visual doesn't support conditional formatting. Why not just use 2 cards,1 for each value?
You can then create a measure for the _Vari % Colour
_Vari_%_REV_HONEY1 Color = IF(CONTAINSSTRING([_Vari_%_REV_HONEY1],"-") , -1 , 1)
and create a CF rule
To give this
Regards
Phil
Proud to be a Super User!
Hi Paul,
That visual doesn't support conditional formatting. Why not just use 2 cards,1 for each value?
You can then create a measure for the _Vari % Colour
_Vari_%_REV_HONEY1 Color = IF(CONTAINSSTRING([_Vari_%_REV_HONEY1],"-") , -1 , 1)
and create a CF rule
To give this
Regards
Phil
Proud to be a Super User!
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 58 | |
| 52 | |
| 42 | |
| 30 | |
| 24 |