CODEWITHSUNDEEP
powerbipowerbi-desktop
jabs
jabs

Reputation: 1848

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.

Upvotes: 0

Views: 45

Answers (2)

Arya
Arya

Reputation: 341

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

Upvotes: 0

Sam Nseir
Sam Nseir

Reputation: 12111

Table 3 is essentially your "bridge" table.

Set-up relationships like so:

Table 1: 1 <--(both)--> * :Table 3: * <--(both)--> 1 :Table 2

Upvotes: 0

Related Questions