topic Re: Trying to get card visual to display nothing instead of Blank in DAX Commands and Tips

Trying to get card visual to display nothing instead of Blank

Anonymous — Thu, 25 Jun 2020 16:49:00 GMT

I have a Card visual on my page, showing the total tax amount. It currently says (Blank) when there is no value to display.

Instead of Blank, I would like it to display nothing. I tried applying the following measures to the Card View as a filter:

Replace Blank With Nothing = IF(ISBLANK(SUM ( YearlySales[Taxes] )),"",SUM ( YearlySales[Taxes] ))

Replace Blank With Nothing = IF((ISBLANK(SUM ( YearlySales[Taxes] )) || (SUM ( YearlySales[Taxes] ) = 0)),"",SUM ( YearlySales[Taxes] ))

But it still says Blank when there is nothing to display. Any suggestions?

Re: Trying to get card visual to display nothing instead of Blank

Anonymous — Thu, 25 Jun 2020 17:01:27 GMT

Hi Anonymous

Try

Replace Blank With Nothing = IF(SUM ( YearlySales[Taxes] ) = BLANK(),0,SUM ( YearlySales[Taxes] ))

https://community.powerbi.com/t5/Desktop/Make-Card-Visual-show-0-not-Blank/m-p/403353

Regards,

Re: Trying to get card visual to display nothing instead of Blank

Anonymous — Thu, 25 Jun 2020 17:10:19 GMT

This did not work either

Re: Trying to get card visual to display nothing instead of Blank

Anonymous — Mon, 29 Jun 2020 11:33:55 GMT

[Base Measure] = SUM( YearlySales[Taxes] ) [Measure For Card] = COALESCE( [Base Measure], "" ) // Bear in mind that if a measure // returns a numeric BLANK(), its value is // treated as 0, so this is true // [measure] = 0. You don't have to // check for many conditions as you do // in you second measure.

Best

Re: Trying to get card visual to display nothing instead of Blank

Anonymous — Mon, 29 Jun 2020 18:32:13 GMT

I was incorrectly trying to apply the measure as a filter, instead of a value, and this is why the measure was not working