Forum Discussion

Plump_Lil_Monk's avatar
Plump_Lil_Monk
Frequent Visitor
3 years ago
Solved

What-If Parameter

Hi I have inherited a PBi dashboard which is a bit of a monster, But for this question, I have put together some mock data and visuals.   Scenario:  Users show which activities they have been doi...
Need Help
  • Migasuke's avatar
    Migasuke
    3 years ago

    Hi Plump_Lil_Monk ,

    Try following logic:
    1. Create your What-If parameter in Model section:


    2.  Create a new measure. Measure should work only for IT and Communication, for the rest the hours will not change. You can try something like this:

    Editable Hours =
    var _Activity = SELECTEDVALUE(TableX[Booking Activities])
    var _Hours = SUM(TableX[Hours Booked])

    return

        SWITCH(
        _Activity,
        "Communication",_Hours * Parameter[Parameter Value],
        "IT",_Hours * Parameter[Parameter Value],
        _Hours)


    FYI - this measure works also with Parameter Value, which is value connected to your What If table and slicer. Combining Parameter Value with Hours will solve your problem.

    I Have an example in my own matrix.
    As you can see, slicer has value = 10, so my hours in IT and Communication are 10x bigger. Other values are the same:

     

     

     

Plump_Lil_Monk's avatar
Plump_Lil_Monk
Frequent Visitor
3 years ago

Migasuke Thanks for your reply, much appreciated.

Apologies, I should have been more precise with my requirement, but I will take your example and expand.

I need to be able to show that if IT and Comms booking activity is increased by a certain amount to contract (let's say 10), how would that affect the overall percentage displayed in the % card?


Thanks

 

Thanks