Forum Discussion

semidevil's avatar
semidevil
Helper I
8 years ago

How to hide a visual based on slicer

I have 2 independent line charts that I need to place in my powerBi page.  However,  at any point in time, only 1 chart is applicable.  Is there a way for me to have a slicer that will let me only display only 1 chart at a time.  (i,e  when one chart is selected, the other one will be hidden, white out, etc), just as long as I don have to see both charts at the same time. 

15 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    I have this same need. I know how to toggle charts from a button using a bookmark (like in the youtube video) but what I really want is for the chart visibility to be toggled according to the slicer selection.

     

    Anyone know of a way to do that?

     

    Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi semidevil,

     

    Could you please provide some sample data?

    • semidevil's avatar
      semidevil
      Helper I

      I actually dont see an 'attach' button but i'll describe the best I can. 

      suppose I have 2 line charts:  one for V1 and one for V2.  I want to overlay them right on top of eachother.  I also have a main slicer.  If I filter for V1,  I want to see only my V1 line chart, and my V2 line chart should not be visible.  If I filter for V2, V1 chart should not be visible.

  • Anonymous's avatar
    Anonymous
    Not applicable

    I have this same need. I know how to toggle charts/pages from a button using a bookmark but I want the chart visibility to be toggled according to the slicer selection.

     

    Can anyone help me in this?

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Team,

       

      You can achieve this in bringing Bookmarks and Selection Pane into your report. You can hide your visuals based on the selection of your toggle button.

       

      Regards,

      Pradeep

      • Anonymous's avatar
        Anonymous
        Not applicable

        Thank you.

         

        I have already achieved this by using the same Bookmarks and Sselection Pane, but my requirement is to show/hide reports based on the value of slicer.

        Is there any option by which we can define the event action based on slicer value in which we can call Bookmarks ?

  • I too have a requirement to hide visuals based on a slicer.

    e.g. If the available measures from primary slicer are, say 'Time' or 'Throughput', one of the secondary slicers becomes non-applicable

     

    Secondary Slicer #1:  'Hours' or 'Minutes'

    Secondary Slicer #2: 'Linear Metres' or 'Square Metres'

     

    I acknwowledge (and have used) bookmarking techniques based on buttons as these object have the 'Action' attribute. However, my requirement, if possible, is based solely on the slicer selection.

     

    Any feedback most appreciated.

     

    Steve

     

     

  • Same here, how do you hide visuals based on response count less than 10? Or any other count measure?