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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote 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
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

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

January Power BI Update Carousel

Power BI Monthly Update - January 2026

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