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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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.

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.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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