Hold/Pass transactions based on Customer feedback

[fareedice]

Hi There

My data source is Synapse. I need to create a flag based on Transaction count which is greater than 100. Flag categories are "Hold" & "Pass"

If the transaction count is >100 I need to create a flag in Power BI as "Hold" and if  it is less than <=100 as "Pass".  --- This logic I have implemented in Power BI by Pulling the data into Synapse.

Here, I have a special requirement.  If a cutomer says, the Item A has reported correct transactions then, I need to turn this flag from "Hold" to "Pass".. I am not sure what is the best solution here, but this should happen based on automated approach with a small approve button in Power Bi Dashboard so that when i click on, It will automaticaly change from Hold to Pass (OR) some automated idea/approach I need please. Kindly assist. 

Item	Transaction Count	Derived Flag	Customer Confirmation
A	200	Hold	PASS
B	5	PASS	PASS
C	67	PASS	PASS
D	89	PASS	PASS
E	23	PASS	PASS
F	76	PASS	PASS
G	101	HOLD	HOLD
H	202	HOLD	HOLD

Thank you so much!!

[Syndicate_Admin]

but this should happen based on automated approach with a small approve button in Power Bi Dashboard so that when i click on, It will automaticaly change from Hold to Pass

The data write back options in Power BI range from abysmal to non-existent.  You can consider including a PowerApps visual that could flip the column,  but the UX will not be very great.

[fareedice]

Sure, Thank you!! Will explore using PowerAPPs