How to filter Max(Date) - 31 days ?

[suvechha]

Hi All ,

In my chart I use Day Month in X axis ... Can I filter by using Date and the condition will be Max(Date) -31 days 

[TheoC]

Hi @suvechha 

If my earlier post doesn't achieve what you are after, you can also use the Relative Filter to achieve the identical outcome. Alternatively, you can use 1 month etc rather than 31 days (similar to that of the earlier post).

Hope this helps  🙂

Theo

[suvechha]

Hi TheoC,

This one worked, but the sort order not working correct . Will you be able to help me ?

Currently the sort order like below -

But it should be like below-

[Anonymous]

@suvechha 

I believe relative slicer will do your favor. 

Use a relative date slicer or filter in Power BI - Power BI | Microsoft Docs

Best regards
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[TheoC]

Hi @suvechha 

You should be able to adjust the Date field to the following criteria:

The output will look like the below (note that my Date table in this example has 30 September as the max date):

Hope this helps 🙂

Theo