Slicer with multiple "unrelated" fields/columns

[Anonymous]

I have three "unrelated" columns with similar data. 

Clothing Style 1 (for example, value is: Skirt)

Clothing Style 2 (for example, value is: Top)

Clothing Style 3 (for example, value is: Pants)

How do I use Slicer that shows me values from all of above three fields/columns? (Heirarchy Slicer does not suit my need)

Any calculated column or measure that can be combined with Slicer?

Alternatively (if using Slicer is not possible),

Or any other filter that can list all values from three different fields/columns in a dropdown?

Thank you in advance for your support.

[Anonymous]

i workaround this by unpivoting columns (Clothing Style 1, Clothing Style 2, Clothing Style 3) and using resulting Value for Slicer.

[Anonymous · Accepted solution]

Hi @Anonymous ,

You may create a slicer table.

slicer = 
DISTINCT (
    UNION (
        SELECTCOLUMNS ( 'Table', "style", 'Table'[Clothing Style 1] ),
        SELECTCOLUMNS ( 'Table', "style", 'Table'[Clothing Style 2] ),
        SELECTCOLUMNS ( 'Table', "style", 'Table'[Clothing Style 3] )
    )
)

I don't see any value in your sample data. What's your expected out put?

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , in case you want in one slicer that Hierarchical slicer from feb release id better option (which seems like not a choice)

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/#_Hierarchical_slicer

You can combine value in a single slicer put putting different filter would be a challenge

In case you need control value in different slicer you can use this option

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

[Anonymous]

I do not need control value in different slicer.

Slicer allows only one Field. However I need to add three unrelated Fields (all three Fields from same Table) to one Slicer. Is there a way to achieve it?

Table

Customer	Clothing Style 1	Clothing Style 2	Clothing Style 3
Rachel	Pants	Blouse	Scarf
Samantha	Cocktail Dress
Carol	Jeans	Top

Slicer: Clothing Style

All

Pants
Blouse
Scarf
Cocktail Dress
Jeans
Top