Forum Discussion
Filtering last 3 months data in PowerBI
Hi sentsara
If you add a DateTime field to the filter you can use the Relative date filtering option and set your criteria as preferred.
Hi sentsara, that was my issue until i've found out about relative filtering in slicers.
For the last three months or any other time period, instead of using filters, add a date slicer into your report, select carat in upper right of the slicer and select relative from dropdwon. The rest steps are pretty evident, choose last three months and that's done!
You can find the whole text and guideline here:
https://docs.microsoft.com/en-us/power-bi/desktop-slicer-filter-date-range
Hope this helps.
Ehsan
Hi sentsara, that was my issue until i've found out about relative filtering in slicers.
For the last three months or any other time period, instead of using filters, add a date slicer into your report, select carat in upper right of the slicer and select relative from dropdwon. The rest steps are pretty evident, choose last three months and that's done!
You can find the whole text and guideline here:
https://docs.microsoft.com/en-us/power-bi/desktop-slicer-filter-date-range
Hope this helps.
Ehsan
Thanks kingdom.