Forum Discussion
Advocate IRemove 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.
Advocate IOk, 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.