Forum Discussion

EZgrafton's avatar
EZgrafton
Advocate II
10 years ago

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...
Sean's avatar
Sean
Community Champion
10 years ago

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...

 

 

Read more about how to create here...

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

EZgrafton's avatar
EZgrafton
Advocate II
10 years ago

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! :)