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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
iglesias6
Helper II
Helper II

ISBLANK() is not working properly

This image will help you:

 

iglesias6_0-1694722554915.png

 

Im using a measure to colour the background of a card. I have the problem that the ISBLANK() function isnt working.

 

It is always giving a TRUE value when in this case should be FALSE.

 

What can I do to fix it??

 

8 REPLIES 8
ChiragGarg2512
Solution Sage
Solution Sage

Can a sample data be shared so that, the problem can be checked hands-on?

 

Sadly I cannot

Okay, no problem. I might have been able to help you more with a sample data. Best way to go around it can be to check every step, like what is the value of prueba coming in another measure, is it showing blank or not. 

 

Yes! I thought the same but as I showed in the first image, the value of prueba is the date in the Card called Prueba.

 

After that I didnt know what to do, so I post it to see if someone knew anything about this.

ChiragGarg2512
Solution Sage
Solution Sage

Guessing that [Prueba] is a date column, try writing ISBLANK(Values([Prueba])) instead.

Hope it works for you

Thank You

@iglesias6 

Im sorry, this is "Prueba" measure

iglesias6_0-1694777135223.png

 

And here I have your try:

iglesias6_1-1694777244975.png

 

It is not working 😞

Any ideas?

 

@iglesias6, Are you sure it's not the "red" from the 2nd  if conditon.

Also the card reads Stories_in Backlog instead of stories_in.

Yes! Here is the explanation:

iglesias6_0-1694778983282.png

Im using "Stories_in" as condition filtering to give it a colour.

 

Then, just to show you: im changing the first "Red" to "Blue". Im getting this:

iglesias6_1-1694779180818.png

Background colour now is Blue because its giving back that "ISBLANK(...)" as true

 

 

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors