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

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

    Hi Stephen,

    Thanks for reply.

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

    Also with multiple choices.

     

    • 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