cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
martinmcmillz Regular Visitor
Regular Visitor

What if parameter and Analyze in Excel

Hi All

 

So I have a Power BI Report with a number of sliders with 'What If Parameters' to influence the figures in my data. 

For example; my business development app has a figure for revenue that I apply to reduce the figure by say 90% to give a true indication of future revenue based on our win rates. (So, leads we win 1 in 10)...So if my lead values are a total of £100M, I want £10M to come through). I have a measure for this called 'Factored Revenue'.

Capture.PNG

When I Analyze in Excel, these values are not coming into the data model ready for additional analysis.

Is there a way I can bring that 'default value' through rather than hard wire them in?

 

1 REPLY 1
Highlighted
Super User
Super User

Re: What if parameter and Analyze in Excel

Hi there

You should be able to see the tables in your data model and then use them as a slicer?
Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"