One fixed filter in visualisation

[Borntoreport]

Hello community,

I have a dataset with sales from different salesperson for different years. The plan is to creat a dashboard for each salesperson so they can filter and visualize the content in their own way. Each salesperson should have access to all the data but shouldnt be able to see the sales from other salesperson.

One solution is to split up the data at the beginning. This way i would only upload in "dashboard Mr.Fisher" the sales of Mr. Fisher, but for more than 100 users it takes a lot of time. Is it possible to fix only one filter e.g. salesperson = Mr.Fisher and the others are still flexible?

[greggyb]

It sounds like you'd like to use role based security in a SSAS model, either Tabular or Multidimensional.