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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ovonel
Post Prodigy
Post Prodigy

Make a measure display 0 instead of blank in 'card' visualization

I have my measure Revenue YearToDate as

 

CALCULATE( [Revenue] , DATESYTD('Date'[Date],"31/05" ))


For dates with no revenue... If I choose a 'card' visualization I get the value (blank) instead of 0, why is that? how can I change it to display 0 instead of 'blank'?

3 REPLIES 3
ovonel
Post Prodigy
Post Prodigy

Thanks, I was wondering... this link Power BI: What is DAX? And Why you Should (or Should Not) Learn It | by ZhongTr0n | Towards Data Sci...

 

Says: "When displaying numerical data in a card, for example ‘revenue’, it will return ‘blank’ if you set your filters in a way there is no revenue to show. However, a more natural way to display ‘no revenue’ should be ‘0’ instead of ‘blank’. With a very simple DAX expression, you can yourself create a measure adding a ‘0’ to the formula, meaning you will never have to see ‘blank’ again.

 

Why the link says its very simple? it doesnt look like that...

Anonymous
Not applicable

I guess it's subjective, what one person considers simple might not be the same for another. Only the author could really answer your question. 

Anonymous
Not applicable

add +0 to the end of your measure 

 

 

CALCULATE( [Revenue] , DATESYTD('Date'[Date],"31/05" ))+0

 

 

You could also tie it into an IF statement, for example 

 

= 
VAR _RevenueYearToDate = CALCULATE( [Revenue] , DATESYTD('Date'[Date],"31/05" ))

Return 

IF(_RevenueYearToDate= "null" , 0 ,_RevenueYearToDate)

 


To answer your question, it's resulting in "null" or "blank" because that is the answer. If it has nothing to calculate (because the values are blank) the answer is Blank. If it were calculating 1-1 then the answer would be 0 but "blank" - "blank" = "blank" i.e. no values can be found, therefore the result is blank. 


Remember in binary "0" is a value in its own right. So if your "Revenue" column is "null" and not "0" it's treated as a null value, which is different to 0. 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors