display only data from last 12 month from today

[toto1303]

Hi all,
I want to count id by month but only on the last 12 months.
I added a relative date filter on the visual but it does not change the output.

To be more specific, I would like that my x axis contains all the months from november 2019 to november 2020, even if the count is 0

for more details, the pbix is available here

thanks for your help!

[toto1303]

Thank you @camargos88 , It works perfectly!

[camargos88 · Accepted solution]

@toto1303 ,

Check the attached file.

You need to disconnect the date table from your data table.

[amitchandak]

@toto1303 , Not very clear. Add +0 to the measure

[toto1303]

thank for you answer,
actually, the problem is on the x axis. as you can see on the image, the months goes from january 2019 to december 2020 but I only want to see the last 12 months ie from november 2019 to november 2020