Using DAX in a Visual to update column values in a table

[jeffw14]

I have a Sales and Commission Report/Visual that uses a Date Slicer to present the data within the selected date range. Is there a way  using DAX and a Button (or selection) to update a column in the table for each of the rows presented in the visual to a YES value?

I would like to present the commissions to the user in the visual, have them click a Paid Button, and then have the field Comission_Paid updated to a "Yes" value in my Commissions Table for each row presented in the visual.

Thank you 

[v-yiruan-msft]

Hi @jeffw14 ,

Please review the content in the following links by using Power Apps and check whether they are what you want.

Power BI Write Back with Power Apps

Power BI write-back functionality with Power Platform services

Best Regards

[amitchandak]

@jeffw14 , You can not use slicer values in a calculated columns