Forum Discussion
Helper IKeeping most recent value on slicers
Anonymous - I am wondering if igordossantos issue is similar to the issue with Dashboard tiles not refreshing when the year and month change and therefore have to be re-pinned. I believe that greggyb solved this in another thread. Basically, the idea was to create a column that had a flag if it was the current month and current year and then filter on that instead of the actual month and year.
Not sure if this is the problem and having a devil of a time finding that thread.
Found it:
Community ChampionAnonymous - I am wondering if igordossantos issue is similar to the issue with Dashboard tiles not refreshing when the year and month change and therefore have to be re-pinned. I believe that greggyb solved this in another thread. Basically, the idea was to create a column that had a flag if it was the current month and current year and then filter on that instead of the actual month and year.
Not sure if this is the problem and having a devil of a time finding that thread.
Found it:
Helper II implemented the idea suggested by Greg_Deckler and it has been working.
We now have two new columns in our Date Dimension called:
- CurrentFiscalPeriod
- CurrentCalendarPeriod
And those are being used on PBI reports.
So far so good and thanks for the great support guys.