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
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

nayan28apr 

in your original DAX, you set period title is 05, is that May? Your screenshot shows the result of Jan.

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

What I want is :

1. This matrix should show latest period information as we proceed further. Like P6 started now and so on.

2. This formula works fine for me but it shows blank. This is basically that combination rows are not present in the data for that day. I want to show 0 when no values.

3. As soon as i apply condition or look to catch this scnarios. All values coming as 0 and metrix started showing values from P1 to P6.

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

    nayan28apr 

    have you tried to modify the last part of DAX

    iF(not(isblank(monthlysales)),monthlysales,0)

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

      Thanks for the reply.
      Yes, i tried this initially but not worked as well.

      IF(NOT(ISBLANK(MonthlySales)),MonthlySales,0)

      As soon as I pass zero, all becomes zero.

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

        nayan28apr 

        can you share the pbix file after removing sensitive data?