Forum Discussion
help with slicer and relationship
I am new to power BI, I have 2 tables and which doesnt have unique columns on both the tables. I am using direct query to Power BI. Example as below: Product Map Red 001 white 020 Re...
you can achieve this by merging the tables in query editor
I merged the tables, when i use slicer as map column - i get the results(description) of products from both columns.
- When select 1 product -> white 020, i get the below result
Product white 020 Red 001 Blue 100 Yellow 111 Description W00201 R00011 B01001 Y10001 Description W00202 R00012 B01002 Y10002 I unable to get this result
- When select 1 product -> Red 001, i get the below result
Product Red 001 white 020 Description R00011 W00201 Description R00012 W00202
