Forum Discussion
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=eyJrIjoiMjVhOTBiYzctOTlhNC00NDU1LWJhYzctNWYxMmNlNWRiMGQ4IiwidCI6IjM4NmVlOWIzLTRlNTktNGIxNC04ZTU5LTIxYWYyOTk5MTk1YyJ9
Picture shows the 2 hidden slicers (Received, Donated) that are hidden in the top right corner in the embedded version)
I tried to use
5 Replies
- amitchandak
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
Compare two Brands: https://youtu.be/exN4nTewgbc
@ 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.
is there a way to use a slicer to change filter to other columns not connected to the current slicer?
- v-chenwuz-msft
Community Support
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.
