One Slicer multi select for multiple columns

Question

HiI am trying to make one slicer so the result shows ISO 9001, ISO 14001 and ISO 45001 columnsAll 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)&nbsp;I have tried a solution like this by making a table (Enter data) of the selected headers,&nbsp;and use a calculated column:SelectedColumn = Var d= SELECTEDVALUE(Headers[Header])ReturnSWITCH(d, "ISO 9001", LL[ISO 9001], "ISO 14001", LL[ISO 14001], "ISO 45001", LL[ISO 45001] )&nbsp;But it not working.&nbsp;Do you have a solution for this?

anonymous · Answer

Hi&nbsp;TerCh&nbsp;,
&nbsp;
The matrix you show is a visual. I need your raw data.
Judging by your description, your&nbsp;[ISO 9001],&nbsp;[ISO 14001],&nbsp;[ISO 45001]&nbsp;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.
&nbsp;
&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

terch · Answer

Hi Stephen,Thanks for reply.Yes you understand correct. So I need one slicer that filter these multiple columns.Also with multiple choices.&nbsp;

anonymous · Answer

Hi&nbsp;TerCh&nbsp;,
&nbsp;
You could create separate table by entering data.

&nbsp;
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.

&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly
&nbsp;

halfglassdarkly · Answer

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.

terch · Answer

Hi Sephen,Thank you very much, this works fine.However when nothing (or all) is chosen then nothing is shown in the result table.&nbsp;1. Is it possilbe to show all?2. Is it possible to have multiple selection t.ex. ISO9001 and ISO 14001 ?&nbsp;Thanks againBR TerCh

Forum Discussion

One Slicer multi select for multiple columns

5 Replies

Related content

Parameter slicer with measure for multiple columns

Single Slicer to Filter Multiple Columns

Slicer for filtering several columns

Once Slicer for multiple columns

Sequential Order column based on multiple criteria