Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I am trying to get a button in which I can create simulations on the dashboard page op PowerBI in where I can customly add a percentage change e.g. prices change by x % and costs per category change by % percent and I am trying to find a solution to let the user do this on the dashboard. Is this possible and if so how can this be achieved?
So it would be a dynamic scenario calculator in which the user can modify the parameter easily on the dashboard.
Any help would be greatly appreciated.
KR,
Marco
Solved! Go to Solution.
Hi Marco,
You have 2 options:
1. Use What if parameter: for this you can move your calculation to DAX instead of Power query. Go to Modeling Menu and choose "New Parameter" on the ribbon.
2. Use Power Query parameter and bind to the data model. This works in DirectQuery models only.
I would suggest to go for 1st option - should be faster. You can share your Power BI file if you need more help on the solution.
Hi Marco,
You have 2 options:
1. Use What if parameter: for this you can move your calculation to DAX instead of Power query. Go to Modeling Menu and choose "New Parameter" on the ribbon.
2. Use Power Query parameter and bind to the data model. This works in DirectQuery models only.
I would suggest to go for 1st option - should be faster. You can share your Power BI file if you need more help on the solution.
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |