Forum Discussion

data_data1's avatar
data_data1
Frequent Visitor
3 years ago
Solved

Dynamically Display Groups of Columns

Hello,

 

I have a table with 6 product columns.  The first 2 product column names contain the text 'Group 1.'   The next 2 product column names contain the text 'Group 2.'   The last 2 product column names contain the text 'Group 3.'  

 

I would like to have a slicer that contains 3 values: Group1, Group 2, and Group 3.

If Group 1 is selected, then only the columns with 'Group 1' in their name should be displayed.  The same logic should be applied to the other groups.  

 

I would've uploaded the .pbix file but couldn't figure out how.

Thank you!

 

 

 

 

2 Replies