Forum Discussion

tomijs's avatar
tomijs
Frequent Visitor
9 years ago
Solved

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. ...
Need Help
  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    9 years ago

    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.

dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago

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.

tomijs's avatar
tomijs
Frequent Visitor
9 years ago

Ok thanks a lot!