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

Dynamic Increase

Hello,

 

I am trying to create a model where users (executive team) can visualise the effect of a targeted salary increase for which they (users) can modify the %. In essence, the Power BI end user (the management team) can select a random value for the salary increase and the Power BI model will show the appropriate results (additional cost, employees affected, etc.) without going behind the scene. The salary increase could be any randon number between zero and 10%. I hope my question makes sense. Woman Frustrated

 

Any ideas?

3 REPLIES 3
Super User
Super User

Re: Dynamic Increase

Unfortunately, I don't believe that there are any options that you are going to like. Parameters are now supported in queries, so that might be one route, but you probably do not want your users having to run the query and enter the % increase just to get the answer. If I understand your question correctly, you would like the user from the dashboard or report level to be able to enter a number and have the visuals reflect that. There is no "user input" at the report/dashboard level of which I am aware. Would make a nice "Idea" if it does not already exist.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Sean Super Contributor
Super Contributor

Re: Dynamic Increase

@EZgrafton Have you considered parameter tables? You will have to use pre-set numbers (in your case between 0% and 10%)

 

Here's what the basic Measure would look like for each slicer...

Option 1? =
IF (
    HASONEVALUE ( Recommend1[Option 1] ),
    ( [Measure] * VALUES ( Recommend1[Multiply By1] ) ),
    [Measure]
)

 

And here's the result with 3 slicers and 3 such measures...

 

Disconnected Slicers.png

 

Read more about how to create here...

http://www.daxpatterns.com/parameter-table/

EZgrafton Regular Visitor
Regular Visitor

Re: Dynamic Increase

Thank you for your suggestion, Sean.

 

I will try to replicate it. However, I was thinking of something more flexible like any value from 0 to 10, so for example 3.77%, Using your idea, I will have to develop a table that contains all possible values between 0 and 10 and on the slicer they would not look visually appealing. Would it be possible to have a sliding slicer? I think I've seen the concept of sliding data on a time table type of visual. Does anybody know how to make it happen?

 

Any creative idea is welcomed! Smiley Happy

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 37 members 1,096 guests