Forum Discussion
nayan28apr
Helper I
Helper Ihow 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...
ryan_mayu
Super User
Super Userhave you tried to modify the last part of DAX
iF(not(isblank(monthlysales)),monthlysales,0)
nayan28aprHelper I
Helper IThanks 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
can you share the pbix file after removing sensitive data?
- nayan28apr
Hi, Thanks for your reply.
Attached sample pbix on the below location:
https://drive.google.com/file/d/1SJPSZConmHt-soh9QoVg98VsSz7cPHxJ/view?usp=sharing
Thanks