Forum Discussion
Custom Relative Month Filter
Hey Community, TLDR: Given monthly data of past few years, how can I create a relative month filter, where I have the option to filter data of last X month (where my reference month is not today...
The standard approach is similar to
- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app