Modifying filters on Dashboard visuals without re-pinning from original report

To fix this limitation, I created a [YearIndex] in my Calendar table 'DateKey' and used this when repinning the next year. "[YearIndex] = 0" instead of the Year = 2024
This is the code for YearIndex

YearIndex = DATEDIFF(Today(), 'DateKey'[Date],YEAR)

Current year is always 0
Last year is always -1

Year before last is always -2

etc...

They update and roll correctly.

Its also handy to do a Month Index for rolling 6 month views. Heres the code.

MonthIndex = DATEDIFF(Today(), 'DateKey'[Date], Month)

I have not had a need for WeekIndex or DayIndex in Power BI, but you get the idea, but have used them in Qlik.

Using these to pin will keep to the current year.
Applying [YearIndex] = 0 will keep the visual to current year.

Using these to pin will keep relevant to rolling months.
Applying [MonthIndex] > -6 will keep the visual to a rolling 6 months including current month
Applying [MonthIndex] >= -6 AND [MonthIndex] < 0 will keep the visual to a rolling full 6 months excluding current month.

Using these to pin will rest rolling months at the start of each year.
Applying [Year Index] = 0 AND [Month Index] > -6 will reset any rolling 6 month view at the start of each year.

I find these very useful in PowerBI pinning, but really would love the ability to edit the pinned visuals filters in the Dashboards, even if you can only change used filters or clear them would be handy, but perfect if you could add new filters also. I do feel the Dashboards could be a lot better, but you have to work with what your have.

Hope this helps.

Hi vgeldbr ,

I did some testing as well and it really doesn't work.

Best regards,
Community Support Team_ Scott Chang