Forum Discussion

talham's avatar
talham
New Member
8 years ago
Solved

Dynamic visuals using whatif analysis

I am trying use a whatif analysis parameter in my report.   I have been able to use and update the analysis as expected. My challenge is that I want to use the selected the whatif parameter value t...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Talham,

 

There's a couple of things I can think of without looking at your dataset.

 

  • Have you synced your slicers between Page 1 & 2?  
  • Are you using bookmarks to move between page 1 and 2?  If you are, in the bookmark options, untick the "data" option, otherwise it will revert back to whatever was selected when you created the bookmark.

 

 

talham's avatar
talham
New Member
8 years ago

how do I sync slicers between page 1 and page 2?

 

Ideally I don't want to show any slicers on page 2. Just want to show the one on page 1.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    First, you copy and paste the slicer from page 1 to page 2.  It will ask you if you want to keep the slicers in sync, choose yes.

     

    Then, if you go to View --> Sync Slicers, you can choose to hide the visibility of the slicer, but to still keep it in sync.

     

    This article should help:

     

    https://docs.microsoft.com/en-us/power-bi/desktop-slicers

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    Hi talham

    Your requirement can be achieved by sync slicers.

    Here is a test with sync slicers.

     

     

    Best Regards

    Maggie

    • talham's avatar
      talham
      New Member
      8 years ago

      Note: this update was released in Feb 2018 older versions of Powerbi don't have this functionality.