Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
admin11
Memorable Member
Memorable Member

Advanced card how to make Postfix label change red when value -ve ?

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. 

admin11_0-1614601929893.png

https://www.dropbox.com/s/w79t44y0xkrp0ow/PBT_V2021_350%20ask%20advance%20card%20set%20condition%20f...

Above link is my PBI 

 

Paul

 

Paul

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

@admin11 

 

Download PBIX file

 

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

cfrule1.png

 

To give this

cfrule3.png

 

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

1 REPLY 1
PhilipTreacy
Super User
Super User

@admin11 

 

Download PBIX file

 

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

cfrule1.png

 

To give this

cfrule3.png

 

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors