Relative Date Filter and Marker Button

[Syndicate_Admin]

Hello Community.

I have the following problem.

I have a report, where I use a "panel" to show/hide filters.

In addition, I have a page-level filter where it filters the last month of the data.

Well it occurred to me to add a new button to clean the filters and fucniona, of course it also cleans the filter at the page level and that is precisely the one I would NOT want it to change.

This filter is the one I use at the page level and I would like it to ALWAYS be active.

Add a button that cleans filters that the user might have selected and called a bookmark to do so, the problem as you can see is that it cleans up all filters.

And my page filter restarts, looking like this:

Why do I use page filter ? it's because I need to load several months with data, but in some reports they ONLY want to see the last month, and in others they need to see visuals with the last month and others with every month and this is the way I found to do it.

Greetings.

[v-stephen-msft]

Hi @Syndicate_Admin ,

Sorry, I am a little confused about your screenshots in Spanish.

For your request, I wonder if you can create a calendar table.Then create related DAX to achieve.

Reference: http://sqljason.com/2018/03/display-last-n-months-selected-month-using-single-date-dimension-in-powe...

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

I answer in case someone else serves you, just change the option all the objects by only the selected ones.