One Slicer multi select for multiple columns

[TerCh]

Hi

I am trying to make one slicer so the result shows ISO 9001, ISO 14001 and ISO 45001 columns

All coumns shall be shown as this, but if ex. ISO 14001 is selected, the table only show the 3 last suppliers.

If ISO 14001 and ISO 45001 is selected, the 4 last suppliers is shown.

(the green hocks=1, empty=0)

I have tried a solution like this by making a table (Enter data) of the selected headers, 

and use a calculated column:

SelectedColumn =

Var d= SELECTEDVALUE(Headers[Header])

Return

SWITCH(d, "ISO 9001", LL[ISO 9001], "ISO 14001", LL[ISO 14001], "ISO 45001", LL[ISO 45001] )

But it not working.

Do you have a solution for this?

[halfglassdarkly]

SELECTEDVALUE will only work if your slicer is single selection only, otherwise if you have multiple items in the slicer checked it will return BLANK() by default unless you specify an alternate value in the optional second clause.

Try using CONTAINS to check if a given standard is included in your slicer selection.

[Anonymous]

Hi @TerCh ,

The matrix you show is a visual. I need your raw data.

Judging by your description, your [ISO 9001], [ISO 14001], [ISO 45001] might be columns.

The raw data is similar as follows, right?

If my guess is not correct, please provide the correct raw data and more details, thank you.

Best Regards,

Stephen Tao

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

[TerCh]

Hi Stephen,

Thanks for reply.

Yes you understand correct. So I need one slicer that filter these multiple columns.

Also with multiple choices.

[Anonymous]

Hi @TerCh ,

You could create separate table by entering data.

Create a measure for visual-level filters.

Measure = SWITCH(SELECTEDVALUE('Table (2)'[Category]),"ISO 14001",IF(MAX('Table'[ISO 14001])=1,1),"ISO 45001",IF(MAX('Table'[ISO 45001])=1,1),"ISO 9001",IF(MAX('Table'[ISO 9001])=1,1))

Put the measure into the visual-level filters of the matrix visual and set up show items when the value is 1.

The field of the slicer is from Table (2) and when "ISO 14001" is selected from the slicer, the result is below.

Best Regards,

Stephen Tao

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

[TerCh]

Hi Sephen,

Thank you very much, this works fine.

However when nothing (or all) is chosen then nothing is shown in the result table.

1. Is it possilbe to show all?

2. Is it possible to have multiple selection t.ex. ISO9001 and ISO 14001 ?

Thanks again

BR TerCh