Dashboard Design

[reidiain5]

I am in the process of building a number of HR dashboards and I am keen to ensure if possible these are tailored to our different business areas. As such I wanted to ask is it possible to change the colour and logo design within a global dashboard if a user has access to a single line of business as a filterable option, or if someone has access to a global verson and they select a particular line of business for example the format changes to reflext logo's and formatted styles?

[Anonymous · Accepted solution]

Hi @reidiain5 ,

Here I suggest you to try Row-Level-Security to achieve your goal.

I create a sample to show you how to create a dynamic rls data model.

Fact Table:

User Table:

Logo Table:

Relate all tables by Company column. Then create a new role in [User] by USERPRINCIPALNAME() function.

Let's view as UserA in Power BI Desktop.

View as is a test, RLS will work in Power BI Service.

You need to manage security in Power BI Servcie. For reference: Manage security on your model

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Most likely you are talking about reports.  Use separate reports (and likely separate workspaces) for  your different audiences.