How do i remove "BLANKS" in data cards ?

[Anonymous]

How do i remove "BLANKS" in data cards? 

1) FYI, i put the difference ratio of productivity between 2022 and 2021 (pic attached: the one written blank for 2021) and also together with the increased/decreased icon. The data card show the value when i choose slicer 2022 and blank for 2021. How do I remove the blanks ? 

I watched one tutorial on youtube, they just change the color background of the data cards same with the background of the cards to hide it. 

2) What if I had 10 years of data (2011-2022), how do i find the difference ratio. Below was the DAX that i used to find the difference ratio between 2 years.productivity (mt/ha)

Pengeluaran diff ratio = var _currentyear = MAX(Buah[Tahun])

VAR _pengeluaran_CurrentYear = CALCULATE([Pengeluaran],Buah[Tahun] = _currentyear)

var _pengeluaranPrevYear = CALCULATE([Pengeluaran],Buah[Tahun] = _currentyear-1)

return DIVIDE(_pengeluaran_CurrentYear-_pengeluaranPrevYear,_pengeluaranPrevYear

[parry2k]

@Anonymous If you use a new card visual, you can set a blank value in the format section without dealing with any work arounds. Read more here New card visual | Public preview | Microsoft Power BI Blog | Microsoft Power BI

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️

[Anonymous]

ohh thank you. That's a new thing that I just learned. Unfortunately, i need to do the card one my one. Kudos to you. Maybe next time i can use the multiple card like the one in New Card Visual.  

[Ahmedx]

you need following functions

= COALESCE([measure],"Not Supplied")

or
= SELECTEDVALUE([measure],"Not Supplied")

or

[measure] +0

[Anonymous]

I tried to put +0 at the end of return, and it appear as 0 for 2022. But what if i want to use COALESCE / SELECTED VALUE function. Which part do i need to put it ?

PengeluaranKontan diff ratio = var _currentyear = MAX('T Kontan'[Tahun])

VAR _pengeluaranKontan_CurrentYear = CALCULATE([PengeluaranKontan],'T Kontan'[Tahun] = _currentyear)

var _pengeluaranKontan_PrevYear = CALCULATE([PengeluaranKontan],'T Kontan'[Tahun]= _currentyear-1)

return DIVIDE(_pengeluaranKontan_CurrentYear -_pengeluaranKontan_PrevYear,_pengeluaranKontan_PrevYear) + 0

[Anonymous]

Thank you, but how do i combined it with my current DAX:

Pengeluaran diff ratio = var _currentyear = MAX(Buah[Tahun])

VAR _pengeluaran_CurrentYear = CALCULATE([Pengeluaran],Buah[Tahun] = _currentyear)

var _pengeluaranPrevYear = CALCULATE([Pengeluaran],Buah[Tahun] = _currentyear-1)

return DIVIDE(_pengeluaran_CurrentYear-_pengeluaranPrevYear,_pengeluaranPrevYear