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

Thanks for your reply.

We have P5 starts from May 6th to June5th so it may include May and June also, its not calendar months. Now I add +0 the matrix starts showing from P1 and period title = P5 condition fails.