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


          

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 )