Forum Discussion
Interaction between dropdown in Power BI
For instance I have 2 dropdowns(which is created out of 2 different field columns). If I select a region from the first dropdown list let say Northeast, my other dropdown should also select Northeast.
Is there a way to do this?
vjnvinod,
You can use DAX instead to create the new tables. I haven't found any method to put all the data in a single Matrix visual and filter it using a single slicer.
https://1drv.ms/u/s!AhsotbnGu1Nok0_5dfG96lEqpQr_
Regards,
Lydia
17 Replies
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
dropdown interaction issuedropdown interaction issue
Thanks Greg, Appreciate your time on this, i have attached the screenshot, Actual problem is that if you see in the first screenshot Dropdown when i select the HQ region as Northeast, my Delivery region won't automatically change it to Northeast or Vice versa that means i have to manually check the Northeast in the Delivery region
Look at the Output required screenshot, what i want to achieve?
i want to achieve if i select any dropdown from HQ region (be in Northeast, southwest any other region) or Delivery region(be in Northeast, southwest any other region), it should automatically change and reflect the same in both.
let me know if there is way i can fix this
vjnvinod,
Do the above two columns come from different tables? If so, have you set proper relationship between the two tables?
Regards,
Lydia
Open Format -- > Edit Interactions
See more from https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
