Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

make slicer for multiple columns with binary data structure?

hi, I have columns that correspond to a region coded like below, and would like a slicer that would have this structure

Filter by region:

Northeast
Midwest
South
West
National
Other/Not specified

 

How would I go about doing this if the values are true/false?

 

NortheastMidwestSouthWestNationalOther/Not specified
FALSEFALSEFALSEFALSEFALSETRUE
FALSEFALSEFALSEFALSEFALSETRUE
TRUEFALSETRUEFALSEFALSEFALSE
FALSETRUETRUETRUEFALSEFALSE
FALSEFALSEFALSEFALSETRUEFALSE
FALSETRUEFALSETRUEFALSEFALSE
Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , the second table should have some columns in the row.  seems incomplete

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello, I just have this one table as an example:

      NortheastMidwestSouthWestNationalOther/Not specified
      FALSEFALSEFALSEFALSEFALSETRUE
      FALSEFALSEFALSEFALSEFALSETRUE
      TRUEFALSETRUEFALSEFALSEFALSE
      FALSETRUETRUETRUEFALSEFALSE
      FALSEFALSEFALSEFALSETRUEFALSE
      FALSETRUEFALSETRUEFALSEFALSE
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    Hi Anonymous ,

    Sorry I'm not very clear about your expected result, do you want to get a table contains all the above column names?

    Then filter the columns by the column name slicer?

    Best Regards,
    Community Support Team _ kalyj