Forum Discussion

tvaishnav's avatar
tvaishnav
Helper IV
7 years ago

Repeat same visual based on slicer selection

I have a line chart that displays values for three fields (Field 1,Field 2,Field 3). A slicer is used with single select on. This is because line chart would aggregate the value for Field 1 ,Field 2 and Field 3. That will not make any sense. Visual makes sense when only one value of slicer is selected.

 

Is there a way I can allow a user to select multiple values in a slicer so that multiple visuals will be presented, each showing Field 1,Field 2 and Field 3 for each selection in slicer?

 

Please note that I am using SSAS connection. 

4 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support

    Hi tvaishnav ,

     

    If you mean multi selection in slicer, you can ctrl+left click the values in slicer. If I misunderstood your goal, kindly share your sample data and excepted result to me. Please upload your files to One Drive and share the link here.

     

    Regards,

    Frank

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support

      Hi tvaishnav ,

       

      Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

       

      Regards,
      Frank

    • tvaishnav's avatar
      tvaishnav
      Helper IV

      It is little complicated to create the expected output. I will try to explain once again.

       

      I am looking for a way to create a seperate visualization for each selection in a slicer. For instance visualization show three values field 1, field 2 and field 3 for a slicer value  s1. Now the user wants to select multiple values (s2, s3,s4 etc) in the slicer so that they can have a seperate visual for each selection of slicer. So if slicer selection selects s1,s2,s3,s4 then user wants 4 visuals each showing field 1, field2 and field3. If they remove selection s4, they should see 3 visual each showing field 1,field2,field3. If user now selects slicer value s5 as well, they should see 5 visuals each showing field1,field2,field3.

       

      Is it possible to do this in power bi?

      • gayatrigunnala's avatar
        gayatrigunnala
        New Member

        Hello,

        I have a same requirement of replicating visuals based on slicer selection. Is this possible in power BI?