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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Conditional formatting for card visualization

Hi 
I am trying to figure out a way to make the background of my card visualization more dynamic.

 

image.png
As can be seen here. I'm using values from column name Previous week entry status to display whether the user has submitted the form or not. If the user haven't submitted the form it will display yes with the background color of red. On the contrary, if the value is blank then the background should be green and I would like to replace "blank" with another words. Is it possible? If not can I create custom visual to make this works? thank you all of you guys in advance.

1 ACCEPTED SOLUTION

Card Message =
VAR card_value = SELECTEDVALUE('my table'[my column])
RETURN IF(ISBLANK(card_value),"No Value",card_value )





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


View solution in original post

3 REPLIES 3
kentyler
Solution Sage
Solution Sage

Try using a measure instead of a column to provide the value for the card. Inside of a measure you can test for a blank result and substitue the text you want instead of blank.  If the column is not blank, then just have the measure return the value from the column.





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Anonymous
Not applicable

Could you give me some example of the measure idea. Should I use "If" or something else?

Card Message =
VAR card_value = SELECTEDVALUE('my table'[my column])
RETURN IF(ISBLANK(card_value),"No Value",card_value )





Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!




Join the conversation at We Talk BI find out more about me at Slow BI


Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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