Slicer not working as not unique

[jinweitan]

Hi Hi

I have this table:

Function	Location
1	A
2	A
1	B
3	B
4	C

Wanting to create slicer.

However it seems like the Function and Location is not working well as it is not unique.

Any guides?

[v-shex-msft]

HI @jinweitan,

What type of issues that you faced, can you please explain more clear?

How to Get Your Question Answered Quickly
AFAIK, normally power bi use 'AND' logic to link filters, if you want to achieve other types of logic or filter effects, you can't directly use default filter features to achieve these requirements.

Regards,

Xiaoxin Sheng

[jinweitan]

Hi Hi

I have this table:

Function	Location
1	A
2	A
1	B
3	B
4	C

Wanting to create slicer.

However it seems like the Function and Location is not working well as it is not unique.

Any guides?

[negi007]

@jinweitan Seems like duplicate post. Please close it.

[amitchandak]

@jinweitan ,

Not very clear on error. Function and Location should work as slicers.

else create an independent table

https://www.youtube.com/watch?v=vYxWyt0qNUQ

or

https://www.youtube.com/watch?v=kU2M1LmNvNo

[negi007]

@jinweitan Slicers are working fine. I tried to create at my end like below

1. first visual

2. second visual

let me know if this helps you. in case your problem is something else please let me know

[amitchandak]

@jinweitan , Not very clear on error. Function and Location should work as slicers.

else create an independent table

https://www.youtube.com/watch?v=vYxWyt0qNUQ

or

https://www.youtube.com/watch?v=kU2M1LmNvNo