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 throughout the report. Every time I try to do this, it shows me the default parameter value. See example detail below:
Page 1: whatif parmeter on profit [0-20%] (Profit parameter)
Profit = Total Revenue * Profit parameter
selected value 0.1 default value 0.05
Note: Page 1 has a whatif slider that allows switching / selecting different values
Page 2: calculate profit per employee
Estimated profit / total employees
Note: I want to be able to update calculations on page 2 based on any changes to the whatif parameter on page 1.
Solved! Go to Solution.
There's a couple of things I can think of without looking at your dataset.
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:
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Learn about the exciting things that happened in July.
We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.
We have great updates this month! Click the link for the video with more info.