Forum Discussion

cs_mvo's avatar
cs_mvo
New Member
4 years ago

How to add dropdown menu to every row from another table

Hi ,

 

I would like to create an assignment dashboard which I query from the sql database. 

 

Doc NoDateShipping ViaShipping InfoCustomerAddressAgentDriver
127/05/2022Truck1:00pmABC123John 
227/05/2022Truck3:00pmDEF456Mary 

 

As I dont have the Driver table, I've created a table in power bi with all the drivers name. Now, I would like to add a dropdown list of the drivers name in every row created for my colleague to assign them. How do I achieve this target or if there's better way to achieve this, kindly advice.

 

Thanks in advance!

 

 

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Power BI is a reporting tool, not a disposition tool (unfortunately - the data write back features are very minimal).

     

    you can consider including PowerApps visuals that have this functionality but the UX will be suboptimal.