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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Maggu5
Frequent Visitor

Slicer to Filter 2 different visuals

Would anyone be willing to give me a hint how to simplify my model (1slicers only and remove the 2hidden slicers?
The aim is that the slicer on the top, filters received (left) / donations (right). Currently I am using 2 hidden slicers (top right) that are synced and interacting with the visible slicer and filtering the visuals.
https://app.powerbi.com/view?r=eyJrIjoiMjVhOTBiYzctOTlhNC00NDU1LWJhYzctNWYxMmNlNWRiMGQ4IiwidCI6IjM4N...
Picture shows the 2 hidden slicers (Received, Donated) that are hidden in the top right corner in the embedded version)
forum.jpg
I tried to use 

ReceiverFilter =
IF(SELECTEDVALUE('Detailed Receipts'[Party])='Detailed Receipts'[Group filter], 1, 0)
and the first impression looked alright but it's messing up the filtered data with non relevant.
5 REPLIES 5
Maggu5
Frequent Visitor

is there a way to use a slicer to change filter to other columns not connected to the current slicer?

Hi @Maggu5 ,

 

Yes, it is possible.

You can try use some measure like this to identify if the current row is in what you selected.

IF( SELECTEDVALUE('RightTable'[GROUP]) in values('Slicer'[GROUP]),1,0)

 

Then put the measure in right table's filter pane and set it show itmes which is 1.

 

Best Regards

Community Support Team _ chenwu zhu

 

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

Thank you for your input.
The solution works for results that are not summarized. In the SUM version it mixes up rows that are not supposed to be there.

amitchandak
Super User
Super User

@Maggu5 , Not very clear.  See if these can help

 

How Interactions Work- Split Page using interactions to compare: https://youtu.be/GIfRKzhMaR4

 

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg

 

 

Compare two Brands: https://youtu.be/exN4nTewgbc

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@ amitchandak Thank you for your input.

The current version does work.
My intention is to remove the 2 slicers (they are hidden in the embedded version above) that are marked as hidden in the picture and only use the 1 slicer at the top.
Each slicer (different column filters the Name selected it the same in both columns) controls the visual below them.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors