cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Allow audience introduce goal manually for any measure they select

Does exists a way to manually enter a goal in power bi? where the audience can introduce the value. I am not a frequent user of Dax but I will apreciate some guide if this can be achieve or it need to be done under very specific  Power bi feature.

I am looking to do under power bi desktop.

 

The external measure goal introduce may vary depending the type of goal cuz could be in percentage or integer number format.

 

thanks in advance

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Allow audience introduce goal manually for any measure they select

Hi @perezco ,

 

You can use What-IF parameter for that, check this link:

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

 

Ricardo


Did I answer your question? Mark my post as a solution!
Ricardo

View solution in original post

Highlighted
Advocate II
Advocate II

Re: Allow audience introduce goal manually for any measure they select

Thanks @camargos88 ,
I did for one Measure using  the What-IF parameter in a Calculate Measure.

But I am not sure this can be done for several  Measures (KPI alias Measure).

 

Is What-IF parameter the only function tthat Power BI ?

This is what I am trying...

cluster.1588117374.png

 

This what I have for one measure. ( I have also measure that are precentage value).

cluster.1588117877.png

I am aware I cannot create a dynamic calculated column based on what-if parameter.

View solution in original post

10 REPLIES 10
Highlighted
Community Champion
Community Champion

Re: Allow audience introduce goal manually for any measure they select

Hi @perezco ,

 

You can use What-IF parameter for that, check this link:

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

 

Ricardo


Did I answer your question? Mark my post as a solution!
Ricardo

View solution in original post

Highlighted
Advocate II
Advocate II

Re: Allow audience introduce goal manually for any measure they select

Thanks @camargos88 ,
I did for one Measure using  the What-IF parameter in a Calculate Measure.

But I am not sure this can be done for several  Measures (KPI alias Measure).

 

Is What-IF parameter the only function tthat Power BI ?

This is what I am trying...

cluster.1588117374.png

 

This what I have for one measure. ( I have also measure that are precentage value).

cluster.1588117877.png

I am aware I cannot create a dynamic calculated column based on what-if parameter.

View solution in original post

Highlighted
Community Champion
Community Champion

Re: Allow audience introduce goal manually for any measure they select

Hi @perezco ,

 

What are you trying to do ? I've used what-if as dynamic parameter, it works very well.

 

Give us more detail about your requirements.

 

Ricardo


Did I answer your question? Mark my post as a solution!
Ricardo

Highlighted
Advocate II
Advocate II

Re: Allow audience introduce goal manually for any measure they select

Allow the audience Introduce goals for different KPI.

So IF I have 5 kpi it will means 5 different goals.
not sure this will work

Highlighted
Community Champion
Community Champion

Re: Allow audience introduce goal manually for any measure they select

@perezco ,

 

I did the same thing before!! 

I had to add 3 what ifs for distinct goals.

 

Ricardo


Did I answer your question? Mark my post as a solution!
Ricardo

Highlighted
Advocate II
Advocate II

Re: Allow audience introduce goal manually for any measure they select

Does you audience accept the solution of three what ifs for distinct goals?
Did you include dynamic kpi in those three distinct goals for "what if" function?

Highlighted
Community Champion
Community Champion

Re: Allow audience introduce goal manually for any measure they select

@perezco ,

 

Yes, the inputs were about target sales for product groups. Each product group had a target sales and they could simulate the sales and income salary based on range of values.

 

Ricardo


Did I answer your question? Mark my post as a solution!
Ricardo

Highlighted
Advocate II
Advocate II

Re: Allow audience introduce goal manually for any measure they select

I mean.. Is possible   include dynamic kpi inside of each individually to each distinct goals for "what if" function?

Highlighted
Community Champion
Community Champion

Re: Allow audience introduce goal manually for any measure they select

@perezco ,

 

It's possible to compose the kpi, the user will input the scenario and the measure gets the value and returnes the result.

 

Ricardo


Did I answer your question? Mark my post as a solution!
Ricardo

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors