Is it possible to change the filter selection of several visuals at once?

[sisachosudo]

Hello everybody.

My Power BI report is linked to a database so every month I have to refresh the report to get the last month's data.

Some visuals are showing figures for the last month and other visuals are showing the last 12-month trend or the last semester. They are all mixed and that's why I cannot apply the filter (Month) to the whole page.

The problem is that it is becoming very tedious work to do. Every month I have to refresh the report and then update the filter panel for 30 - 40 visuals to show only last month. And do that for 14 similar reports.

Is there a way to change the filters of several visuals at once?  

Remember I cannot apply the filter at Page-level or the trends will show only one month's data.

Thank you.

[sisachosudo]

Thank you amitchandak for posting.

I just checked now and the solution posted above solved the issue (in case it helps somebody else).

Take care all.

[sisachosudo · Accepted solution]

I think a found an answer here

I believe that from now on, the filters will refresh by themselves and I don't need to go through all the visuals.

[amitchandak]

@sisachosudo , Not very clear, relative date slicer.

or default month or year using a column

Month Type = Switch( True(),
eomonth([Date],0) = eomonth(Today(),-1),"Last Month" , //Last Month
eomonth([Date],0)= eomonth(Today(),0),"This Month" , //This Month
[Month Year]
)

[sisachosudo]

Thanks amitchandak,

I created the column with your code but when I apply it to all the visuals ("Filters on this page"), the trends disappear showing only last month's data. 

When I want that chart to show the last 12 months:

That's why I am forced to go through the visuals, one by one, changing the filter (Month).

I am trying to find a way to avoid this and save lots of time.