Forum Discussion

TerCh's avatar
TerCh
Frequent Visitor
3 years ago

One Slicer multi select for multiple columns

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 s...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
TerCh
Frequent Visitor
3 years ago

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