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.
Hey guys,
I am trying to show count of values with different status options.
for example, i have 4 different status:
Status | Count of AEF |
Draft | 0 |
Submitted | 34 |
Approved | 55 |
Rejected | 5 |
So I have made a card that shows this data as it's values. Now if i just select Draft (on a status slicer), the card shows "(Blank)". Is there a way for the card to show 0 instead of blank written out?
Thank you for your help in advance.
Solved! Go to Solution.
Hi @C097986,
You could create a measure by IF(ISBLANK(),0, ) like below to get your expected output.
New Measure = if(ISBLANK([count Measure]),0,[count Measure])
In addition, you could have a reference of this similar thread.
You also could vote this similar idea here which has been submitted in Power BI ideas forum and add your comments there to improve Power BI and make this feature coming sooner.
Best Regards,
Cherry
Hi @C097986,
You could create a measure by IF(ISBLANK(),0, ) like below to get your expected output.
New Measure = if(ISBLANK([count Measure]),0,[count Measure])
In addition, you could have a reference of this similar thread.
You also could vote this similar idea here which has been submitted in Power BI ideas forum and add your comments there to improve Power BI and make this feature coming sooner.
Best Regards,
Cherry
thank you, I read through all the thread and this is what i used but using an IF measure sure seems very inefficient if there multiple cards present. I voted for a better fix and all i hope is that they make simple changes like these in their next upgrade.
thank you for your help.
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 |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |