Filtering Dashboard Data Based on User | Syncfusion Blogs
Live Chat Icon For mobile
Live Chat Icon
Popular Categories.NET  (179).NET Core  (28).NET MAUI  (214)Angular  (110)ASP.NET  (51)ASP.NET Core  (83)ASP.NET MVC  (90)Azure  (41)Black Friday Deal  (1)Blazor  (226)BoldSign  (15)DocIO  (24)Essential JS 2  (109)Essential Studio  (200)File Formats  (69)Flutter  (133)JavaScript  (226)Microsoft  (120)PDF  (81)Python  (1)React  (105)Streamlit  (1)Succinctly series  (131)Syncfusion  (942)TypeScript  (33)Uno Platform  (3)UWP  (3)Vue  (45)Webinar  (52)Windows Forms  (61)WinUI  (71)WPF  (163)Xamarin  (160)XlsIO  (38)Other CategoriesBarcode  (5)BI  (29)Bold BI  (8)Bold Reports  (2)Build conference  (9)Business intelligence  (55)Button  (4)C#  (158)Chart  (140)Chart of the week  (54)Cloud  (15)Company  (443)Dashboard  (8)Data Science  (3)Data Validation  (8)DataGrid  (70)Development  (658)Doc  (8)DockingManager  (1)eBook  (99)Enterprise  (22)Entity Framework  (7)Essential Tools  (14)Excel  (43)Extensions  (22)File Manager  (7)Gantt  (19)Gauge  (12)Git  (5)Grid  (31)HTML  (13)Installer  (2)Knockout  (2)Language  (1)LINQPad  (1)Linux  (2)M-Commerce  (1)Metro Studio  (11)Mobile  (512)Mobile MVC  (9)OLAP server  (1)Open source  (1)Orubase  (12)Partners  (21)PDF viewer  (43)Performance  (12)PHP  (2)PivotGrid  (4)Predictive Analytics  (6)Report Server  (3)Reporting  (10)Reporting / Back Office  (11)Rich Text Editor  (12)Road Map  (12)Scheduler  (54)Security  (4)SfDataGrid  (9)Silverlight  (21)Sneak Peek  (31)Solution Services  (4)Spreadsheet  (11)SQL  (14)Stock Chart  (1)Surface  (4)Tablets  (5)Theme  (12)Tips and Tricks  (112)UI  (393)Uncategorized  (68)Unix  (2)User interface  (68)Visual State Manager  (2)Visual Studio  (31)Visual Studio Code  (19)Web  (614)What's new  (333)Windows 8  (19)Windows App  (2)Windows Phone  (15)Windows Phone 7  (9)WinRT  (26)

Filtering Dashboard Data Based on User

If you want to give multiple users access to differing data sets while at the same time restricting some users’ access to certain data sets, it isn’t manageable to maintain multiple versions of the same dashboard, especially if you’re working with a lot of users. 

In this post, we’ll cover the how to show a dashboard with data specific to a certain user.

The Syncfusion Dashboard Platform provides the solution. The dashboard that needs to be restricted for user-based data access has to be configured with user-value mapping through the Dashboard Designer with users of the Dashboard Server.

Take the Northwind Traders management system as an example. It has primary entities associated with it: Sales Representative, Sales Manager, and Vice President. Each of these entities has a different level of data access, as illustrated in the following diagram.

User Filter: Flow Diagram

Each of the mentioned entities needs a different level of data access. To configure accordingly, pick the existing dashboard that needs to be configured with the user filter or use the Dashboard Designer to design a new one with the required visuals showcasing the needed data.

Open the dashboard through the Dashboard Designer and log in to the Dashboard Server with an administrator account that can define data access to all registered users.

Dashboard Server Login: Top Right in Dashboard Designer

Select User Filter… from the Server menu. 

User Filter… Option

In the Choose Data Column dialog, select the data source and the specific column in which data needs to be filtered for different users. Then click Choose.

Choosing Column Name Based on User Filter

Open the User Filters window and map each user in the left pane with the allowable values for a specific column in the right pane. Here, Andrew will have access to the sales data associated with all the employees; Steven will have access to the sales data associated with a few of those employees: Michael, Robert, and Anne; and others will only have access to their own data. 

Andrew’s Employee Access

Steven’s Employee Access

Once you finish the configuration, click OK to save the filter changes. Save the dashboard, and then publish to the Dashboard Server. 

Now, by logging in with a specific user account through the Dashboard Server, you can access restricted data with the same dashboard.

Steven’s Login

Dashboard Showing Michael’s, Robert’s, and Anne’s Sales Records for Steven

User-based filtering is a useful tool when you need to show different users the same categories of data but with different data sources. For more details about all the features of user-based filtering, please refer to our “Configuring User Filter Using User Filter Window” documentation.


Share this post:

Comments (2)

I’ll right away seize your rss feed as I can’t in finding your e-mail subscription link or
e-newsletter service. Do you’ve any? Please permit me recognise in order that I may just subscribe.


Hi Eve,
We are working on providing email subscription for the blogs. We will update you once when it is available.

Comments are closed.

Popular Now

Be the first to get updates

Subscribe RSS feed