Search code examples
powerbipowerbi-desktop

PowerBI Slicer showing single value from group of values

I have a field with the following data:

Customer Locations
1 Cleveland, Detroit, Tucson
2 Atlanta, Buffalo, Detroit

I want to be able to slicer on a single location from the list contained in the row (i.e. the filter would contain the individual values).

Filter
Atlanta
Buffalo
Cleveland
Detroit
Tucson

So, if the user selected Cleveland, only customer 1 would show (and the table would have all the locations displayed). If Detroit, both Customers would show.

I also have a different table I could use with the data set up a different way. The data in that table looks like this:

Customer Locations
1 Cleveland
1 Detroit
1 Tucson
2 Atlanta
2 Buffalo
2 Detroit

Using either table, I'd want the result to be the same - to have a slicer show a single location, but in the table all locations for the customer are displayed.

Solution

  • Relationship Diagram

    enter image description here Make the relation ship as per the image and also, you can create a CustomerList from Customer table by splitting the names by row