Use a Parameter to update selected values

[ragnezza]

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!

[v-mdharahman]

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 Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[lbendlin]

I want users to be able to edit the quantity of "Value"

how?  Through which mechanism?

[ragnezza]

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.

[lbendlin · Accepted solution]

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.