Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
I was incorrectly trying to apply the measure as a filter, instead of a value, and this is why the measure was not working
[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
D
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,
HN
This did not work either
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |