Forum Discussion
Interaction between dropdown in Power BI
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
Anonymous
Also i see that you have created 3 tables, out of which 2 tables are created (duplicated) to set the relation between HQ and Delivery.
The sample i have shared with you doesn't have many coloumns, note that the actual data set has 100+ coloumns, that means if we duplicate and set a relationship, i was wondering whether it will have performance issue or not.
Regards, vinod
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
AnonymousGreg_Deckler
thanks Lydia, appreciate your feedback.!
is that something we can submit as an idea to implement in Power BI?
at the moment i can use the option you have shared, but i still see challenges regarding the position of the matrix. if you see with the selection of the region, this matrix position keeps moving its position and don't fit appropriately and makes it looks weird. i have applied the lock option in the power BI but still it does really helps.
may be if you have solution for this, do let me know
Anonymous
Hi Lydia,
Can you please help checking when i select a region, my outbound details (lets say filter of Northeast region) are not interacting with my Pie chart and the table.
please find below the scrubbed PBIX file
https://www.dropbox.com/s/20u6v9kpwr6xehc/Testcheck.pbix?dl=0
thanks for your help as always