Two average lines on Line chart.

[Anonymous]

Hi All,

I have columns like projectID and actual contribution in my data.

I am taking projectID on X axis and actual contribution on Y axis. 

I need to add two average lines on a line chart such that first average line will indicate average of all actual contribution values of whole department where as second line will indicate average of actual contribution of perticular project manager within respective department.

    I want my first average line should be static if any person from same department logged in to power BI (by using RLS) and second line should vary according to the contribution status of each project for that respective project manager.

I am not able to find out how to keep actual contribution line static for everytime for same department.

Any help is appreciated.

Thanks in advance.

Shraddha

[TomMartens]

Hey,

Assuming there are 2 departments, with 5 projects each, each project has 1 dedicated projectmanager.

At the moment where you use RLS to restrict access for one projectmanager to his project, he will not be able to see values from his department.

For this reason, I would use this approach:

Use RLS to restrict access to projects on department level. This provide the data to calculate the average contribution to all projects on department level.

To calculate the average of dedicated projects of the current login (the project manager) I would assign the login as a column in the project table. This will allow to use the DAX function USERNAME() to filter down the accessible projects.

If you have to ensure that a projectmanager has only access to a dedicated project(s), you have to provide an aggregation table that stores the project values on departmentlevel w/o a relationship to the project table.

Hope this helps

Regards

Tom

[Anonymous]

HI @TomMartens,

Thanks for your reply.

Approch which you have mensioned is perfect but in my case if I am applying RLS to restrict access to projects on department level then my other visuals gets affected, as I am developing a dashboard from project manager's point of view.

What I want to achieve from this line chart is project manager should be able to comapre his projects' status with departmental project status. 

Regards,

Shraddha.