What-if Parameter

[anacarol84]

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

[anacarol84]

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

[jayalathamsyd]

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]

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]

Happy you solved it 💪

[SpartaBI · Accepted solution]

@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