Forum Discussion
Solved
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 t...
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/DAX-Count-and-Include-Zeros/m-p/462269#M214520
Ashish_Mathur
Super User
Super UserHi,
Try this measure
=IF(ISBLANK(SUM(Data[Sales])),0,SUM(Data[Sales]))
Hope this helps.
I tried but that doesn't work.
- Ashish_Mathur
Hi,
Share the link from where i can download your PBI file.