Forum Discussion

IF's avatar
IF
Post Prodigy
5 years ago
Solved

changing slicer value with selection on table/matrix/chart

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!

 

Need Help
  • negi007's avatar
    negi007
    5 years ago

    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's avatar
    v-alq-msft
    5 years ago

    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.

4 Replies

  • Portrek's avatar
    Portrek
    Resolver III
    5 years ago

    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's avatar
      IF
      Post Prodigy
      5 years ago

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

  • negi007's avatar
    negi007
    Community Champion
    5 years ago

    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's avatar
    v-alq-msft
    Community Support
    5 years ago

    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.