Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Once Slicer for multiple columns

Hi, I am trying to create a single slicer for the below table, i would like to see all of the table when i first load the report, but when i come to slicer "Part One/Part Two/Part Three/Part Four/Par...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Anonymous,

     

    There is a solution below. Please check out the demo in the attachment.

    1. Create a new table as slicer table.

    SlicerTable =
DISTINCT (
    UNION (
        VALUES ( Table1[Part One] ),
        VALUES ( Table1[Part Two] ),
        VALUES ( Table1[Part Three] ),
        VALUES ( Table1[Part Four] ),
        VALUES ( Table1[Part Five] )
    )
)

    2. Rename the column name of the new table. (optional)

    3. Do not establish any relationships!

    4. Create a measure.

    Measure =
IF (
    MIN ( 'Table1'[Part One] ) IN VALUES ( SlicerTable[values] )
        || MIN ( 'Table1'[Part Two] ) IN VALUES ( SlicerTable[values] )
        || MIN ( 'Table1'[Part Three] ) IN VALUES ( SlicerTable[values] )
        || MIN ( 'Table1'[Part Four] ) IN VALUES ( SlicerTable[values] )
        || MIN ( 'Table1'[Part Five] ) IN VALUES ( SlicerTable[values] ),
    1,
    BLANK ()
)

    Once_Slicer_for_multiple_columns

     

    Best Regards,

    Dale

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi there,

 

I am trying to implement a similar slicer and was already able to implement this solution. However, I would like to be able to select multiple values in the slicer and then have it display only the rows that posses all these functions, and not just one of them as it does now. 

 

For example if in this case I would select 'base management' and 'production shope' it would only display the 1st, 3rd and 8th row.

 

Thanks in advance! 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      Unfortunately, I haven't. I'll be working on it again today and if I figure anything out I'll share it here and on your thread. Cheers! Anna
      • Artie's avatar
        Artie
        Frequent Visitor
        6 years ago

        Hi there,

        Just thinking outloud.  Have you tried unpivoting the data?

         

        Perhaps you can come with a table with the following columns:

        Threat, Node,Activity, Part, Code (value).

         

        Then make up a matrix visual and use column "Part" as the column header.

         

        The only "inconvenience" for your users is that the matrix would be dynamic, would show columns only when there is information.  The other one is that data can not be exported to Excel in a tabular way but linear (most of users want to see the exported data as it shows in Power Bi).

         

        Regards.