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 September 15. Request your voucher.

Reply
NMil
Advocate I
Advocate I

Advanced Card format text when (Blank)

Hi all,

 

Due to the normal cards being unable to left allign, and the 'card with states' being slow and unable to 'bold' text I am currently using 'advance card' visualisation on my dashboard.

 

I have (Blank) values pop up as i am using the same measures on a table. If I don't use the (Blank) as a result in the formula, the matrix table includes the entire date table.

 

I want the (Blank) values font to appear as white so it looks blank in the dashboard when there's no data.

 

Is there a way to do this?

 

Why are the cards functions so bad 😕

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@NMil , usually conditional formatting does not work with blank. But if field values conditional formatting is supported in that visual, You can use this measure in conditional formatting using field value

You can use

measure = if(isblank([measure]), "white", "black")

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
v-xiaotang
Community Support
Community Support

Hi @NMil 

Could you share some pictures of that visual and the dax expression in it? So that I can see if it can achieve this effect by changing part of the code.

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@NMil , usually conditional formatting does not work with blank. But if field values conditional formatting is supported in that visual, You can use this measure in conditional formatting using field value

You can use

measure = if(isblank([measure]), "white", "black")

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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.