Forum Discussion
Use a Parameter to update selected values
Hello - I'm looking for some guidance.
I have a table that looks like this.
| ID1 | ID2 | Value |
| AAA | 5563 | 1000 |
| AAA | 7272 | 50 |
| BBB | 4786 | 400 |
| BBB | 9288 | 3500 |
I want users to be able to edit the quantity of "Value" for multiple (not all) combinations of ID1&ID2.
My approach is this:
- add a Parameter that lets users enter a value, which will update the selected combination of ID1&ID2.
- a Measure will update "Value" based on the selected combination of IDs (AAA & 7272 in this example) and based on the number entered in the Parameter (1000 in this example).
The problem is that whenever I select a different combination of ID1&ID2, a new Value is updated and the previous one resets (ie. AAA & 7272 goes back to 50).
Can I update multiple Values based on different selections using this approach? Or is this doable only with PowerApps or other ways?
Thanks!
In Power BI you can only filter. You cannot change anything. Your Parameter is a filter.
To change things Power BI would need to have a concept of mutable variables, and would need to support data write back - ideally into the semantic model but also to the original source.
Changing data in a Power BI report would also be very problematic in a multi user environment. What if two users change the same value at the same time? etc.
4 Replies
I want users to be able to edit the quantity of "Value"how? Through which mechanism?
I'm looking to do this only through Power BI Desktop.
I was thinking to use the Parameter to let users enter the new Values.
In Power BI you can only filter. You cannot change anything. Your Parameter is a filter.
To change things Power BI would need to have a concept of mutable variables, and would need to support data write back - ideally into the semantic model but also to the original source.
Changing data in a Power BI report would also be very problematic in a multi user environment. What if two users change the same value at the same time? etc.
Hi ragnezza,
Thanks for reaching out to the Microsoft fabric community forum.
It looks like you want to change values of rows using measures. As lbendlin already responded to your query, please go through his response and mark it as solution if it solves your issue.
I would also take a moment to thank lbendlin, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support TeamIf this post helps then please mark it as a solution, so that other members find it more quickly.
Thank you.
