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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
AngeXu
New Member

Syncing two slicers/parameters

 
1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @AngeXu 
The slicers can only filter each other, not "select" the value in another slicer like on the attached :

Ritaf1983_0-1701493629688.png

but if you need to use the value of a second slicer according to the selection on the first one, it will work, for example formula 

test = max('Table'[CLR]
will return the value of the second column filtered by the first one
Ritaf1983_1-1701493846573.png

the pbix is attached 

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @AngeXu 
The slicers can only filter each other, not "select" the value in another slicer like on the attached :

Ritaf1983_0-1701493629688.png

but if you need to use the value of a second slicer according to the selection on the first one, it will work, for example formula 

test = max('Table'[CLR]
will return the value of the second column filtered by the first one
Ritaf1983_1-1701493846573.png

the pbix is attached 

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors