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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
Super User
Super User

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
Super User
Super User

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.