Forum Discussion
Remove Filters Not working with Date Slicer
Ok, found the issue. It's called Auto Exist, which I don't know anything about. But since I was working within my Calendar table, it wasn't working. When I made a second small table with the month names and connected it to my Calendar table, then it worked!
Of course, then I found this PowerBI post here, that I wish I'd seen earlier: https://community.fabric.microsoft.com/t5/Desktop/DAX-REMOVEFILTERS-Issues/td-p/2834453#:~:text=If%20it%20is%20caused%20by%20auto%2Dexist%20the,way%20to%20create%20a%20dimension%20table%20is.
Hi WilliamHF
Wilson_ Thank you very much for your prompt reply.
Here allow me to explain to you the reason for the blank values in the matrix.
Since you used the slicer to intercept the dates from 1/1/2020 to 3/31/2024. Therefore, the 2024 matrix will only have data from January to March. Therefore, MEASURE will not be populated with dates from April 2024 onwards.
I hope I have explained this clearly to you.
If you want the selection in the slicer not to affect the presentation of the matrix, here I provide a way to do it:
Click on the slicer and go to the "Format" tab. Select "Edit interactions" and click on the circle in the upper right corner of the matrix view.
Incidentally, clicking on the graph on the left restores the slicer filtering. As shown below:
In the meantime, I have made changes to your code.
Measure = CALCULATE(MAX('Calendar'[Sort Month]), ALL('Calendar'))
To prove that the slicer is working, I similarly created a MEASURE to show the maximum date under the action of the slicer.
Max Date = MAX('Calendar'[Date])
Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, thanks for the input. I know about turning off the interaction between slicers. But shouldn't 'Removefilters' (or 'All') be able to override a date slicer? I thought that was the whole point of those 'removefilters' functions--that they remove all outside filters.