Filtering last 3 months data in PowerBI

[sentsara]

Hi,

Right now,I manually filter the last 3 months from the visual filter "DayNumberOfMonth" =April,May and June..

I need dyanamically the last 3 months should be filtered every month.how this can be done?

VisualLevel Filter

[Phil_Seamark · Accepted solution]

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.

[Kingdom4400 · Accepted solution]

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

[sentsara]

Thanks kingdom.

[Phil_Seamark · Accepted solution]

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.

[Arvind_123]

Hi @Phil_Seamark ,

Suppose If I have only month column and don't have date column in that case how can we achieve this scenario.
I have month column, Month number and year column with me.

Thanks,

Arvind

[Britannina]

Hi Phil!
I have a line graph with this filter, but I also need that if the user wants to look for other date, could do it. For example look for the same month but on 2022.

[Malkeet83]

But this will be filter all data of report

[sentsara]

Thanks phil got it.