cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sentsara Regular Visitor
Regular Visitor

Filtering last 3 months data in PowerBI

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?

VisualFilter.PNGVisualLevel Filter

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Phil_Seamark Super Contributor
Super Contributor

Re: 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.

 

image.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Kingdom4400 Frequent Visitor
Frequent Visitor

Re: Filtering last 3 months data in PowerBI

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

5 REPLIES 5
Phil_Seamark Super Contributor
Super Contributor

Re: 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.

 

image.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Kingdom4400 Frequent Visitor
Frequent Visitor

Re: Filtering last 3 months data in PowerBI

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 Regular Visitor
Regular Visitor

Re: Filtering last 3 months data in PowerBI

Thanks kingdom.

sentsara Regular Visitor
Regular Visitor

Re: Filtering last 3 months data in PowerBI

Thanks phil got it.

Malkeet83 Frequent Visitor
Frequent Visitor

Re: Filtering last 3 months data in PowerBI

But this will be filter all data of report