Forum Discussion

nayan28apr's avatar
nayan28apr
Icon for Helper I rankHelper I
5 years ago

how to replace blank with zero in a metrix

Hi,   I have to replace blank with zero in metrix visual in power bi. I am showing sales of 3 dimension region, cluster, country as drill down rows against period, month and day wise on the column...
General Comment
Need Help
Show and Tell
Tips and Tricks
nayan28apr's avatar
nayan28apr
Icon for Helper I rankHelper I
5 years ago

Thanks for the reply.
I have tried as below, but it doesn't work and showing zeros.

This is strange to see it start showing P1, P2 in the column when we add +0

 

nayan28apr's avatar
nayan28apr
Icon for Helper I rankHelper I
5 years ago

I have also tried with count of rows in if condition as below,
it identified blank records and only give zero for it. But don't show actual records which has values in it. Issue the same it shows P1 to P3 though we have given P5.

 

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    5 years ago

    nayan28apr 

    the fasteset way is to add a visual filter and select P05