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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
vannavada
Frequent Visitor

Ability to filter few columns

For my requirement the user wants to know if he can only get 10 columns out of 50 columns that are details page.

Ex: There is a summary page with all the KPIs. User A wants to drill through to the detail page and only get his conserned 10 columns that he wants to see

Also from the same summary page with the KPIS, if user B wants to drill through to the details page and get all the 50 columns.

And so on, multiple users and not all wants to see all 50 columns. So I have to develop all these versions from a single details page and single summary page.

 

Thanks,

Prashanthi

2 REPLIES 2
amitchandak
Super User
Super User

@vannavada , you can consider field parameters, user can add additional columns as per need

 

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE

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

@amitchandak Thank you for you reply. However, this looks like a solution where if we want to change the graph according to another field this would work. But my requirement is when a user tries to drill through from summary page, he should be able to go to details page and see only his desired 6 columns(the detail page will have around 50 columns)

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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.

Top Solution Authors
Top Kudoed Authors