Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to replace empty cells to zero (0) in matrix column values using direct mode.

i am using direct query, 2 columns product service, product status and below is sample data product service, product status phase 1               open phase 2               started phase 3     ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

    I had a look at your file and have updated the file as you require.

    Download the file here

     

    Appreciate your kudo!! Mark this post as solution if this works for you.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

If possible can you share pbix removing sensitive data or a sampke pbix?

 

Appreciate your kudos!! 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

 

Hi Nikhil,

 

Thanks for your time, please check the sample file below. I have tried with both measure and measure 2 but still i am not able to show 0 instead of blank vallues. 

 

https://1drv.ms/u/s!AlARJq6xd5KedVlP0zJpo2xgG_s?e=tR2Okt

 

Please share your ideas and solution. Thank you.

 

Thanks,

Mahi1827