Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
data_data1
Frequent Visitor

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.'  

 

data_data1_0-1665157694160.png

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

data_data1_2-1665157932484.png

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!

 

 

 

 

1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

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/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

2 REPLIES 2
data_data1
Frequent Visitor

That works.  Thanks Tom!

tackytechtom
Super User
Super User

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/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.