Forum Discussion

deeptigeorge's avatar
deeptigeorge
Frequent Visitor
8 years ago
Solved

Column Displayed in a table Based on Slicer Selection

Hi Everyone,

 

I have a filter say Title,Name,Order No,Author,Genere,Type, etc upto 20 which allows multiple selection.

I have a data source which has these columns. I don't want all the columns to be displayed at once.

Based on the filters selected those columns should be displayed in the table.

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi deeptigeorge,

     

    Based on below sample dataset, you could unpivot columns first.

     

    Then, add [Selected items] into slicer, use a Matrix visual to display data.

     

    Best regards,

    Yuliana Gu

1 Reply

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

    Hi deeptigeorge,

     

    Based on below sample dataset, you could unpivot columns first.

     

    Then, add [Selected items] into slicer, use a Matrix visual to display data.

     

    Best regards,

    Yuliana Gu