Dax for dynamically show the last 12 months data in a visual

[Danteee]

Hi team,

I am new to Power BI and i have created a column chart where I have a single data table for the past 2 years,i only needed the last 12 months data to show in the chart dynamically to my client

 This is my visual

I have created a dax measure for this one

I created this measure and inserted into values in the chart but however i am getting all the data for the past two years. Can anybody help me on this

[Danteee]

Thanks @JoeBarry for your help i will accept your reply as my solution, much appreciated.

[Danteee]

Hi @JoeBarry 

I have added the total measure in the visual and also added the date in the filter pane selected "is in the last 12 months" and it shows till Oct only, may i know why its showing till oct only

Thanks in advance

[JoeBarry]

Hi @Danteee 

Does your table have data from 21/09/2022 to the 30/09/2022? I would say October has data and in the context of the last 12 months including today, then October is correct if there is no data in the range mentioned

[JoeBarry · Accepted solution]

Hi @Danteee 

• Add the Total Values measure to your visual.
• Highlight your visual
• Within the filter pane on the right of your screen, add the date column from your table to the filter, this won't add the date to your visual
• Choose Relative date from the dropdown, and choose in the last 12 months

Hope this helps

Joe

If this post helps, then please Accept it as the solution