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). ...
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.