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
  • SpartaBI's avatar
    SpartaBI
    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.


    Showcase Report – Contoso By SpartaBI


          

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


    Showcase Report – Contoso By SpartaBI