Forum Discussion
MattKav
Advocate I
Advocate IDefault a filter to most-recent Month
I have a report page with a Tile filter down the side of Months, which works great for users to view data and insight relative to that month. Source data is updated automatically each month, therefor...
dharmendars007
Memorable Member
Memorable MemberHello MattKav ,
Please use the below approches
This measure will calculate the latest available month from your data
LatestMonth =
CALCULATE(
MAX('DateTable'[Month]),
ALL('DateTable') -- Ignores existing filters to get the true max month)
Create Another Measure to Check If It’s the Latest Month
IsLatestMonth =
IF(MAX('DateTable'[Month]) = [LatestMonth],1,0)
Add a Visual Level Filter to the Report Tile (Slicer)
1. Add a Slicer or Tile visual for the Month field.
2.Use the IsLatestMonth measure as a visual-level filter.
3. Set the filter to "IsLatestMonth = 1". This ensures that when the report loads, the slicer shows the most recent month by default.
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S