Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
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.
@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]
)
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.
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |