Cannot change format of New Filter Experience on published report

[Anonymous]

So I really like the New Filter Experience and appreciate that it allows me to eliminate slicers and recover page space too. I added the filters into some new reports for my colleagues to try and the only feedback was that they did not like the "Last 12 months" as a date selection.

So I changed on my report to "Is on or after" with a start date and "Is on or before" and an end date, applied the filter, saved and published it, but the published report stays stuck on the "last 12 months" configuration.

I re-tried multiple times, cleared browser history, rebooted, deleted and re-created the filter, etc. but no matter how I change the date filter on Desktop the published report sticks to the "Last 12 months" selection and won't reconfigure.

Has anyone else experienced this?

[v-yulgu-msft]

Hi @Anonymous ,

I was not able to reproduce this symptom on my side. 

Which web browser did you use? When you re-published the updated report, did it prompt "replaced successfully"? By the way, if this problem occurs to specific report, would you share this pbix file (without sensitive data) for test?

Regards,

Yuliana Gu

[Anonymous]

IE and Chrome (only). No Firefox or others.

Yes, it said "Published sucessfully" every time, I clicked the "Got it" button, but no change to my Filter settings.

It might be this subtle combination, because other, larger changes to the filter I could easily change by re-publishing. The combination was locking the filter to "Relative date filtering" and publishing, then trying to change to "Advanced filtering" and publishing. The change will not reflect in the published report until you delete the report and dataset off of your dashboard first.

[v-yulgu-msft]

Hi @Anonymous ,

I was not able to reproduce this problem on my side, republishing report applies changes in service. What desktop version did you use? Please update it to the latest release for a try.

Best regards,

Yuliana Gu

[Anonymous]

Always the latest version - it pops reminders as soon as they are released!

[Anonymous]

OK, finally got it.

Turns out the proper combination is that you have to delete the report and dataset off of your dashboard...completely. Remove all traces of it. Then re-publish from Desktop with the new filter settings.

Kind of a PITA it has to be done this way, as I have to go back and re-pin tiles, etc. Why doesn't just publishing with edited fiters reflect the change online???