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

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

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 )

Forum Discussion

What-if Parameter

Related content

What if parameter

What-If Parameter

What-If Parameter with Dynamic Range

What If Parameter

Target Line Based on What-If Parameter