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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Column customizations need to hide some column based on the requirement

Column Customization needs to hide some column based on the requirement: Based on filters to display the columns

For example when you select A in filters columns should show 1,2,3,4,5
or when you select B in filters  columns show 2,3,4,5,6 and removed 1 column

or when you select c in filters  columns show 1,3,4,5,6 could show

Note : without out bookmark or withouts filters is possible could help me on it

1 ACCEPTED SOLUTION
Anonymous
Not applicable

HI @Anonymous,

Current power bi slicer is not able to directly interact with column visibility. I'd like to suggest you do unpvited column on these fields to attribute and value.

Unpivot columns - Power Query | Microsoft Docs

Then you can create a matrix with the raw category as row and attributeas the column, value to the value field. 

After these steps, you can simply use the attribute column as the source of the slicer to control which fields are displayed.

Regards,

Xiaoxin Sheng

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

HI @Anonymous,

Current power bi slicer is not able to directly interact with column visibility. I'd like to suggest you do unpvited column on these fields to attribute and value.

Unpivot columns - Power Query | Microsoft Docs

Then you can create a matrix with the raw category as row and attributeas the column, value to the value field. 

After these steps, you can simply use the attribute column as the source of the slicer to control which fields are displayed.

Regards,

Xiaoxin Sheng

amitchandak
Super User
Super User

@Anonymous , You need to use bookmarks for that

 

Bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

 

Also, check the new feature field parameters, link below

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.