Chart from current month to the last 12

[a10703]

Hey guys,

I hoe you are going well.

I want to create one chart that automatically identifies the current date and shows me data for the last 12 months only.

I create one measure to find  today date : 

Measure: 

AtualDate = TODAY()

and other measure:

DateLast12Months = DATEADD('Table1'[HoradeCriacao], -12, MONTH)

I created a chart and added the Time Created column (my table date and time column) to the X-axis category and the metric I want to analyze to the Y-axis.

But i cant add Filters to the chart with these measures.

Someone can help how to create these chart?

Thank you for your time!

[Kieran_Ultra_23]

Hi @a10703. I would suggest to create a dedicated date table and connect the new date table to the date column in table 1. This is common best practise in Power BI when working with time/dates. Here is a link to help with that. 

https://radacad.com/power-bi-date-or-calendar-table-best-method-dax-or-power-query 

Once you create this 'date table' and connect it to your desired table. You can add the date column from your 'date table' to the filter panel and use reletive filters to select the last 12 months.