Forum Discussion
Post ProdigySlicer not working
Hi,
I have two data tables in Power Query that i link and created relationship. POS[Manufacturer] and Region[Manufacturer]
POS[Manufacturer] has more manufacturers listed than Region[Manufacturer] and it is not 1-1 match. I created measures using 'POS' table however slicer is coming from Region table. When i try to select values from slicer it doesn't change the values in Matrix table that was created using 'POS' table. I suspect issue is Values in POS table is not 1-1 match with Region table. Is there any work around this issue?
2 Replies
- amitchandak
Super User
dokat , Region table should filter POS, Not POS CY
I doubt this best model you can have. Can try to have some additional dimensions? https://www.seerinteractive.com/blog/join-many-many-power-bi/
dokatamitchandak Thanks for your reply. POS CY table is calendar table. I dont think that impacts. I use that table so that it only pulls data for Latest 52 weeks.
