Forum Discussion
Visual level filter not working in app
"Publish it again with a different name.." It might sound silly, but it worked for me.
Did anyone ever get to the bottom of this? I am having the exact same issue. I did note that I was using bookmarks in the report. Perhaps those are causing corruption with the filters somehow?
Click the 3 dots to the right of the bookmark and uncheck "data". That should work
"Publish it again with a different name.." It might sound silly, but it worked for me.
yes, it may work but it can't be called a "solution"...
every time you publish with a different name you lost all the automatic update configuration so you need to reconfigure it. This is really annoying and time consuming when you have more than 10 production reports (each of them using information from multiple sources that you need to add again one by one through the gateway selected...)
please Microsoft... This bug MUST be fixed !!
in case it helps someone...
after a lot of investigation I found that the bug only appear when using relative time data filtering. For example, "this visual only show data from the previous 12 months". In the app, when the report is affected by this bug, this visual will show all range of data (not only 12 last months)
I have change my reports through a lot of "bad" data modelling (like creating calculated field as checkpoint like "this month" or "other month" in order to be able to filter later by this field without being a relative filter) in order to not use this kind of filters and now it all works fine.
I dont know why Microsoft is not fixing this... it makes reports losing a lot of power...
The real issue, as ZC1 points out, is persistent filters being saved and re-applied when the report is viewed in the service. That's why publishing again with a different file name works to restore the defaults. You can reset filters anytime using the green arrow provided in the top right corner (Reset filters, slicers, and other data view changes you've made). Especailly during development, persistent filters can be disabled under Options > Current File > Report Settings.
