Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
sarikei
Helper I
Helper I

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 2
v-xiaotang
Community Support
Community Support

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
Super User
Super User

@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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.