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/Part Five" rather than having a slicer for each one, am i able to create just one so i can show all the data related to them? I already have slicer for Threat and node that work fine.

 

Base table

 

ThreatNodeActivityPart OnePart TwoPart ThreePart FourPart Five
Area OneDownName 1 Base Management Production ShopProduction Shop
Area OneDownName 2Base ManagementProduction ShopFlow AssuranceProduction ShopProduction Shop
Area OneUpName 3 Production ShopBase ManagementProduction ShopFlow Assurance
Area OneUpName 4 Production ShopProcess EngineerArea OpsProduction Shop
Area OneUpName 5 Flow AssuranceProduction ShopArea OpsFlow Assurance
Area OneLeftName 6 Production ShopFlow AssuranceProduction ChemistProduction Shop
Area OneLeftName 7 Production ShopFlow AssuranceProcess EngineerProduction Shop
RoadRightName 8 Base ManagementProduction ShopBase ManagementCorrosion
RoadRightName 9Base ManagementGatewayFlow AssuranceCorrosionCorrosion
Upper DeckRightName 10 Base ManagementProduction ShopBase ManagementFlow Assurance
Upper DeckRightName 11Base ManagementProduction ChemistProcess EngineerArea OpsFlow Assurance

 

 

How i would like it to look once i have selected "base management" in the slicer;

 

ThreatNodeActivityPart OnePart TwoPart ThreePart FourPart Five
Area OneDownName 1 Base Management Production ShopProduction Shop
Area OneUpName 3 Production ShopBase ManagementProduction ShopFlow Assurance
RoadRightName 8 Base ManagementProduction ShopBase ManagementCorrosion
Upper DeckRightName 10 Base ManagementProduction ShopBase ManagementFlow Assurance

 

 

Thanks

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

19 Replies

  • 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! 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    How will this slicer work?

    Why aren't the rows (Name 2, Name 9, Name 11) in the expected result?

     

    Best Regards,

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hello Dale,

       

      Sorry to the late response, Seems that it did not copy correct!

       

      It should look like this;

       

      ThreatNodeActivityPart OnePart TwoPart ThreePart FourPart Five
      Area OneDownName 1 Base Management Production ShopProduction Shop
      Area OneDownName 2Base ManagementProduction ShopFlow AssuranceProduction ShopProduction Shop
      Area OneUpName 3 Production ShopBase ManagementProduction ShopFlow Assurance
      RoadRightName 8 Base ManagementProduction ShopBase ManagementCorrosion
      RoadRightName 9Base ManagementGatewayFlow AssuranceCorrosionCorrosion
      Upper DeckRightName 10 Base ManagementProduction ShopBase ManagementFlow Assurance
      Upper DeckRightName 11Base ManagementProduction ChemistProcess EngineerArea OpsFlow Assurance
      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Even if it is not a slicer, can this be done in a table as show with filters?