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
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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Artie, This does work partially, however, the problem remains that the condition is: 'has one or several of the attributes/parts', however, I am looking for a condition that selects based one one threat having all the selected atttributes.

      Cheers! 
      Anna