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.

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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.

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.