Forum Discussion

aruntd77's avatar
aruntd77
Helper I
8 years ago
Solved

Adding/Removing matrix columns based on Slicer/Filter

Dear Friends,   I saw solution showcase in below link   DXC.Technology Showcase   In page one, Player Details Page, there is provision to add or remove columns from the Table/Matrix. How can I ...
Need Help
Show and Tell
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi aruntd77,

     

    The red section is a slicer visual, which contains the matrix column group values:

     

     

    Assume you create a matrix, put [SalesTerritoryGroup] in matrix column group. You can drag this same field to slicer visual and enable the "Enable 'Select All' option", change mode to DropDown. You can see attached pbix file. 

     

     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi aruntd77,

 

The red section is a slicer visual, which contains the matrix column group values:

 

 

Assume you create a matrix, put [SalesTerritoryGroup] in matrix column group. You can drag this same field to slicer visual and enable the "Enable 'Select All' option", change mode to DropDown. You can see attached pbix file. 

 

 

Best Regards,
Qiuyun Yu 

  • aruntd77's avatar
    aruntd77
    Helper I
    8 years ago

    Your solution gave me a clue to achieve what I wanted. I did Unpivoting on certain columns.