Forum Discussion
Slicer relations
Go to the query editor. Right click on your table/query (on the left side) and select "Reference". Then, with this new table/query, right click on one of the two columns you want and select "Remove Other Columns". Then, with this 1 column table, select the column and go to the Home tab > Remove Rows > Remove Duplicates.
Repeat this process for the second column.
Regarding the key needed to create relationship between the slicer table and fact table, you will need to factor this into your data model otherwise the slicers wont slice anything.
Yes, I am looking more to isolate each column, but do have any link on the ways how to solve it, because I cant find such solution. And thanks in advance!
Go to the query editor. Right click on your table/query (on the left side) and select "Reference". Then, with this new table/query, right click on one of the two columns you want and select "Remove Other Columns". Then, with this 1 column table, select the column and go to the Home tab > Remove Rows > Remove Duplicates.
Repeat this process for the second column.
Regarding the key needed to create relationship between the slicer table and fact table, you will need to factor this into your data model otherwise the slicers wont slice anything.
Ok thanks a lot!