CODEWITHSUNDEEP
filteringpowerbislicers
Talcom
Talcom

Reputation: 11

PowerBi: Mulitple Slicer on single table

I have the following table.

code    reference   name
291     6           Slovenian   
290     6           Serbo-Croatian  
289     6           Polish  
288     6           Czech(Ceske)    
287     6           Hrvatski    
189     6           Ukrainian   
72      10          Friend  
71      10          CD Rack 
7       10          CD-ROM Holder   
69      10          Shelf   
68      10          My computer 
57      6           Russian 
24      6           Italian 
23      6           French  
22      6           German
21      6           English

Now I want to have two slicer on my dashboard to have different filters for my table. At first I make a slicer for field: name and added a filter with the data field reference = 10. So all 5 Names are showed in the slicer. OK. But... when I now added a second slicer for the same field but different reference = 6, PowerBi changed the first filter to = 6 also. So I have two equal slicer instead of different ones.

How can I make different slicers for the same field with different filter criteria?

Example:

Thanks in advance Talcom

Upvotes: 0

Views: 675

Answers (1)

SlipperyD
SlipperyD

Reputation: 91

In my experience it's all about how you set up the data. I would create new columns to use as a filter. Technically you could use them to slice as well.

You could create a new column for both reference numbers:

is_10 = IF(table[reference]=10,1,0)

Repeat for 6.

Now you have 2 new columns to use as filters. Set filter to include only 1 for each where applicable.

Upvotes: 0

Related Questions