Slicer filter help

[Gavin2804]

Hi,

I am trying to see if there is a way to have a slicer only display what options are in the linked Sharepoint. For example the field has options being - All Brands, BSA, BOM, RRB, StG & WBC however the slicer is bringing through all the results from sharepoint that have been selected so far. I would just like set values and the results to filter regards of what is selected for example - If All Brands is selected then BSA, BOM, RRB, StG & WBC appear or if someone selects StG then anything with All Brands or RRB will also appear. Screenshot below for reference;

Thanks!

[amitchandak]

@Gavin2804 , The best way for such is to split this into rows using split by columns.

Sometimes we take distinct values create a new table in the power query and then duplicate the column and split it into rows. Join with the original table on the original filed (not split)

Split column and Combine Columns: https://youtu.be/T30H_fe2uAA