Forum Discussion
Auto filter for Visual based on Slicer selection
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.
2 Replies
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
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.
