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
5 years ago

Hello, thank you so much for your solution.

 

I have done it step by step and I have downloaded your powerbi file and did the same. However, its not filtering based on the "values" slicer. Any idea why or how I can solve it?

 

Your help is very much appreicated.

 

Thanks,

Anonymous's avatar
Anonymous
Not applicable
5 years ago

In case if some one faces the same issue. Add the Measure to the table viz.