Slicer with distinct values from a column that has multiple values?

[bhanes22]

Hey All,

I'm very much a novice when it comes to PowerBI, so please be gentle here. I have an issue where I have a column named specifications in my item master table that has multiple different specs for each item ID,

example: item ID - "2778-FR" has specs: FDA Approved, RGD, GFLT, etc. 

                item ID - "3489-GT" has specs: UP, Dupont Viton, Class VI, FDA Approved, etc. 

What I want to do is have a slicer dropdown that picks out the distinct values from this spec column and then what ever is picked from this slicer will filter the data table below it with the corresponding items that have those specifications. 

[v-jingzhang]

Hi @bhanes22 

You need to have all distinct spec values in a column of an independent table and use this column in a slicer. Then create below measure and drag it into the table visual's filter pane and set value is 1.

Flag = 
VAR selectedSpec = SELECTEDVALUE(specifications[spec])
VAR Specs = SELECTEDVALUE('master table'[specifications])
RETURN
IF(CONTAINSSTRING(Specs,selectedSpec),1,0)

Download the attachment for details.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[bhanes22]

This worked perfectly! Thank you so much for your help! One quick question and its not the end of the world if this is not possible but it doesn't seem to filter properly on multiple spec selections, would that be possible to filter on multiple specs? 

[v-jingzhang · Accepted solution]

Hi @bhanes22 

My previous measure only deals with a single select situation. For multiple specs selections, you could use below measure and set show items when the value is greater than 0.

Flag 2 = 
CALCULATE (
    COUNTROWS ( 'master table' ),
    FILTER (
        'master table',
        SUMX (
            specifications,
            SEARCH ( specifications[spec], 'master table'[specifications], 1, 0 )
        ) > 0
    )
)

I found above measure from below blog, you could refer to it for more ideas.

SEARCH FUNCTION WITH A LIST VALUE - Microsoft Power BI Community

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.