Display the last 12 months data based on Slicer selection

[ignas]

Hello

I have one simple issue. Based on selected month in Slicer I need to have the last 12 months displayed in the graph:

I need both Year and Date Slicer. If I select Date Slicer then I get only that month data. How could I display the last 12 months?

Here is the dashboard:
https://mega.nz/#!uzglxJQa!cqyaSpTT6dINqn65MP-oolW2jjRDNs15AAAAAAAAAAA

Regards,

Ignas

[Greg_Deckler]

You will need a disconnected Date table for your slicer so that it does not impact your visual. You would then grab the MAX of that and then you could build a measure for your visual that only returns a value if it is within the last twelve months based upon that MAX.

[don_writer]

This is exactly what I am looking for but I am not certain I understand your solution. Could you unpack that a little?

I have a Date table.

Are we saying I should have a second separate date tabel that doesn't have a relationship with the fact table? 

How would I grab the MAX of that? Do you mean a measure that's something like:

MaxDate = MAX(Datetable[Date])

What would that measure look like that only returns a value if it is within the last twelve months based on the MAX?

Thank you!

Best regards,

~Don

[ignas]

Hey @don_writer

The solution can be find here:

https://community.powerbi.com/t5/Desktop/Show-last-13-months-based-on-user-single-slicer-selection/t...

Regards,

Ignas

[DebbieE]

Im really struggling with this at the moment and need to apply this a a fair few visuals. Surely there is a simpler way of doing this?  Im struggling to understand both of these solutions.

Currently All I can do is crete a rolling 12 months based on the current date and go from there but the fact its not attached to the filter is not great.

Im using a hierarchy slicer so I drill down 2019 March and I want my visul to show This month and the last 12. I already have a column in my date dim with 'Mar 2019' 'Feb 2019' etc that I thought I could use in the visual