Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have two data tables with below information. I'd like to use them as slicer. How can i link thiese two table since second table has more manufacturers listed than the first one. When i create a relation in Power Query Editor it doesnt work. All my measures are created using the Region Manufacturer table and doesnt respond to changes to slicere created using POS Manufacturer table. Is there any work around this?
Solved! Go to Solution.
@dokat , One way is to append these table
Second, create common dimension tables and create join
https://www.seerinteractive.com/blog/join-many-many-power-bi/
@dokat , One way is to append these table
Second, create common dimension tables and create join
https://www.seerinteractive.com/blog/join-many-many-power-bi/
@amitchandak I successfully created the bridge table however slicer still doent change matrix tale results.
@amitchandak Thank you for your response. Both tables have different columns. Will it still work?
@amitchandak Thank you for your response. Both tables have different columns. Will it still work?