Forum Discussion
Dashboard Design
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?
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Most likely you are talking about reports. Use separate reports (and likely separate workspaces) for your different audiences.
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
