Forum Discussion

anacarol84's avatar
anacarol84
Frequent Visitor
4 years ago
Solved

What-if Parameter

Hello all,
 
I am working on a report that contains what-if parameter.
 
I need to increase the amount of the slicers value from 1000 to millions, but I cannot find a solution due to a PowerBI what-if parameter limitation, and I need some guidance around this issue. The slicers need to be from 0 to millions.
 

Any Ideas, please?

 
Thanks
Need Help

5 Replies

  • anacarol84's avatar
    anacarol84
    Frequent Visitor
    4 years ago

    Hi SpartaBI ,

     

    Thak you for posting the solution, but for me didnt work how I wanted, so I used a different solution to solve my issue.

     

    Thanks anyways

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi anacarol84 

      I am also having similar issue with What If Parameter input. May I know the solution you have used for your issue?
      Apprciate your help on this.

      Thanks



      • anacarol84's avatar
        anacarol84
        Frequent Visitor
        3 years ago

        Hello, I am sorry for the late reply. I was on Maternity leave.

        I created a calculation using this DAX:

        Param Indirect Cost =
        VAR StartValue = 1000
        VAR Increment = StartValue
        VAR EndValue = StartValue * 50000
        RETURN
        GENERATESERIES ( StartValue, EndValue, Increment )

         

         

         

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion
    4 years ago

    anacarol84 create it by yourseld from scratch.
    You can create a parameter table list this in Power Query, start from blank query, write this formula and then convet to table and import it:

    After that just create that measure that does max on that column and you have the same numeric paramter table.


    In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.

    Showcase Report – Contoso By SpartaBI


    Visit SpartaBI website   Visit SpartaBI Linkdin   Visit SpartaBI Facebook

    SpartaBI Logo