changing slicer value with selection on table/matrix/chart

[IF]

Hi,

I am using about 15 slicers on a page. There is also a graph and matrix.  The initial idea was to select from the slicer and display the value in chart/table/matrix. I am thinking when the value in a matrix is selected, the slicers should show only those values.  Do you know if it is possible?

For example; if 95 is selected, I want to see the slicers are showing unit:"C" and category:"z" values automatically.

Thanks in advance!

[negi007 · Accepted solution]

@IF I guess you wish to change the value of slicer basic selection in your visual. I am not sure if it is possible. One slicer can change the value of another slicer. But slicer value does not changes basis selection in the visual.

[v-alq-msft · Accepted solution]

Hi, @IF 

A slicer can affect other slicers and visuals. Visuals can interact with other visuals but they can't affect the selectable items of other slicers. I'd like to suggest you vote on the similar idea and add your comments there to improve Power BI for making this feature coming sooner.

Best Regards

Allan

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

[negi007 · Accepted solution]

@IF I guess you wish to change the value of slicer basic selection in your visual. I am not sure if it is possible. One slicer can change the value of another slicer. But slicer value does not changes basis selection in the visual.

[Portrek]

Set up your relationships by clicking on them with the right mouse button, select properties, and in the cardinality field choose so that they are many to many * --------------- * and not just 1 for many 1 -------------- x, select the filter direction as "both" and this should solve your problem.

[IF]

I have only one table. It looks like it is not possible.