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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
KristofferAJ
Helper III
Helper III

Tips to include all filters for users in a published dashboard

Hi,

I have a dashboard with some pre set filters within the report. Some of the users are requesting to be able to filter on several of the 50-60 columns in the dataset.

 

I wonder if there is a smart way each of the users can do that by themselves? I recon this is a minority who needs this function thus I'm reluctant to implement that many filters in my dashboard.

 

Can the users interested in this feature for instance edit the published dashboard and inlcude the columns of their interst in the filter pane? or can you see another smart option for this feature?

 

Ther end users are used to a very large excel file where they can select 4-6 columns of their interest

 

Your thoughts and ideas are welcome!

Kristoffer

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@KristofferAJ , Unless you give them access to edit mode, they will not be able to add a filter of their choice.

 

You can provide all of those in the filter pane.

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@KristofferAJ , Unless you give them access to edit mode, they will not be able to add a filter of their choice.

 

You can provide all of those in the filter pane.

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

Perhaps an idea is to have two dashbaords one with and without edit mode. Thanks for your comment

Kristoffer

Helpful resources

Announcements
December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.