PowerBi: Mulitple Slicer on single table

Question

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:

First slicer: show me all name rows with reference = 10
Second slicer: show me all name rows with reference = 6

Thanks in advance Talcom

Why not select both on a single slicer? Just turn on multi-select under the slicer Format settings. — Alexis Olson
in the table are 570 different rows with 10 different reference values. its to much for one slicer — Talcom

SlipperyD SlipperyD · Accepted Answer · 2018-11-12T21:19:50

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.

PowerBi: Mulitple Slicer on single table

1 Answers