Dynamically Display Groups of Columns

[data_data1]

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!

[data_data1]

That works.  Thanks Tom!

[tackytechtom · Accepted solution]

Hi @data_data1 ,

I think field parameters could help you with this. Recently, the great @amitchandak held a very pedagocial PBI community show about this topic:

https://www.youtube.com/watch?v=gae11ITerTU&list=PL1N57mwBHtN3a4WNSfgP4xhFIxl6q3atp&index=10

Let me know if this helps!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/