Hi All,
I want to automate the below calculated field "Project Status". Like, I want to provide users options to choose $5k, $10K or 5%, 10% as the options to map project as "OPEN/CLOSE". I don't want user to update the below code. I want a simple way to make the selections.
Please help me solve this problem.
Thanks,
Hammad
Hello,
One way to do this is to add a what-if parameter that they can pick from and you refer it in the measure.
check this link https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
If I answered your question, please mark my post as solution, Appreciate your Kudos👍
Proud to be a Super User! |  |
Hello,
One way to do this is to add a what-if parameter that they can pick from and you refer it in the measure.
check this link https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
If I answered your question, please mark my post as solution, Appreciate your Kudos👍
Proud to be a Super User! | |
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
| User | Count |
|---|---|
| 128 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |
