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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors
Top Kudoed Authors