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.
You can break this table into separate tables with no relationship.
In the query editory, there are a few ways to do it, but basically you are looking to isolate each column in its own table. Of course, the slicer tables need to have a relationship to your fact table in order for the slicers to work, so make sure you think of some index/key to use between the slicer tables and fact tables.
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!