Forum Discussion

fareedice's avatar
fareedice
Frequent Visitor
2 years ago

Hold/Pass transactions based on Customer feedback

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. 

 

 

ItemTransaction CountDerived FlagCustomer Confirmation
A200HoldPASS
B5PASSPASS
C67PASSPASS
D89PASSPASS
E23PASSPASS
F76PASSPASS
G101HOLDHOLD
H202HOLDHOLD

 

 

Thank you so much!!

Need Help

2 Replies

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago
    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's avatar
      fareedice
      Frequent Visitor
      2 years ago

      Sure, Thank you!! Will explore using PowerAPPs