Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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!
User | Count |
---|---|
98 | |
76 | |
74 | |
50 | |
27 |