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


          

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

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    Happy you solved it 💪

  • 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 )