Relative Date Filtering

[HenryJS]

Hi all,

I have created a new date column as per below.

Why can I not use 'Relative Date Filtering'? I would like to only show data in the last 1 week.

Thanks,

Henry

[amitchandak]

In the Model view, check its data type. In case it is text make it as date.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[MartynRamsden · Accepted solution]

Hi @HenryJS 

To use Relative Date filtering, your column must be formatted as Date or Date/time.

To check, click on the column and then select 'Column tools' from the menu bar.

Under 'Data Type' make sure the format is either Date/time or Date.

Best regards,

Martyn

If I answered your question, please help others by accepting it as a solution.