Forum Discussion

C097986's avatar
C097986
Helper I
8 years ago
Solved

visualization not showing blank values

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 R...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    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

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

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

C097986's avatar
C097986
Helper I
8 years ago

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.