Forum Discussion
Slicer relations
Hi I have such issue, so I have 2 columns with data what I want to put in slicers - Mapping and Ratio. Is there any possibility to uncheck relations between these columns when I put them in slicers. For example, I choose for one graph from Mapping column only Product sales, but for other graph I want to choose fro Ratio column Operating income, but I cant do it because they are related. Is there any possibility to break the relations?
| Mapping | Ratio | Amount |
| Product sales | Gross profit | 100 |
| Non product sales | Gross profit | 50 |
| Direct costs | Gross profit | 20 |
| Indirect costs | Operating income | 10 |
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.
4 Replies
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.
