How to make table values change as sliders move

[PabloGiraldo]

I have the table and parameters below created with sliders corresponding to the "Maximum Points" Column. I would like for values in Columns A through D to multiply by specific factors as the sliders move. See second screenshot as how I have it set up in excel.

If I change the "Maximum Points" values then values in Columns A - C will change accordingly. For example Cell E5 has a formula to multiply D5 * O5. Once I can get this working then Total points for each column should be added at the bottom as screenshot below.

Thanks in advance for any help!

[v-jingzhang · Accepted solution]

Hi @PabloGiraldo 

I think I have realized your expected result, please download the PBIX file from here. You will need to add other six categories into it as I only use two in my demo.

Kindly let me know if this helps.

Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[Anonymous]

This link is not working anymore.

[v-jingzhang]

Hi @Anonymous 

Sorry it's long time... I have lost that pbix file. The feature being used is the what-if parameters in Power BI. You can refer to the following blogs to learn more about it. 

Power BI - What If parameters - RADACAD

Getting Started With The "What If" Parameter In Power BI | Enterprise DNA

Best Regards,
Jing

[PabloGiraldo]

Thank you! Exactly what I was looking for.