Forum Discussion
dhpbi
8 years agoNew Member
Make rows in a column persist when slicing
Hello,
I have a PowerBI table and slicer from a Sales data as shown below.
When I filter only one product using the slicer, 'Week No.' disappears if there is no sales for that product.
Is there any way to make all the week numbers stay when the sales is blank for a filtered product?
Thank you.
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/DAX-Count-and-Include-Zeros/m-p/462269#M214520
4 Replies
- Ashish_Mathur
Super User
Hi,
Try this measure
=IF(ISBLANK(SUM(Data[Sales])),0,SUM(Data[Sales]))
Hope this helps.
- dhpbiNew Member
I tried but that doesn't work.
- Ashish_Mathur
Super User
Hi,
Share the link from where i can download your PBI file.
- v-chuncz-msft
Community Support
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/DAX-Count-and-Include-Zeros/m-p/462269#M214520