Auto filter for Visual based on Slicer selection

[sarikei]

Hi,

I have Slicer in my report, with following value defined:

12-2022

11-2022

10-2022

09-2022

08-2022

07-2022

06-2022

05-2022

04-2022

03-2022

02-2022

01-2022

This is the YearMonth value coming from my “Date Table”.

Now I have included this YearMonth as Legend in my Clustered Chart Column visual. What I want to achieve is if user select month value 12-2022, it will automatically select 11-2022 too (so in my YearMonth filter, I have 2 value selected).

How can I set this as selection value in the Filter on this visual for YearMonth?

Many thanks.

[v-xiaotang]

Hi @sarikei 

Thanks for reaching out to us.

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@sarikei , It can not select automatically.

You need to have independent table and slicer values need to be independent table

example

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -2) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI