Displaying text in a matrix calendar

[Karolina_95]

Hi,

I have a data set where I use the matrix to create a calendar overview over the abcences. I have different letters that define different reasons someone was abcent and need for the matrix to display it also taking into consideration that a row level securtity will be applied where only the approver will see their people abcences. So in the below case when Lewis Hamilton logs in he will see only Lady Gaga and Janet Jackson as his emploees and will see the letters displaying the reson they are out

month	Jan
Day	1	2	3	4
Employee
Lady Gaga	V	V
Janet Jackson		S		SD

Overview over approvers vs Employees

Employee	Aprover
Lady Gaga	Lewis Hamilton
Janet Jackson	Lewis Hamilton
Madonna	Bono

Reason for being absent	Letter
Sick	S
Vacation	V

I tried differnt formulas bo no seem to allow for the Values of leter to be displayed using the above filters and helper data.

Any ideas?

[Anonymous · Accepted solution]

Hi  @Karolina_95 ,

You can use Power BI's RLS.

Refer to:

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

Dynamic Row Level Security with Power BI Made Simple - RADACAD

These are the following steps:

1. Add the [Email] column to the table corresponding to the [Aprover] column.

2. Joins the relationship between two tables:

3. Modeling – Manage roles --  [Email] = UserPrincipalName().

4. In Power BI Service, add the corresponding Email to the Workspace and give the permission as View.

Note that the workspace role of the user who is sharing the report must be View, otherwise RLS will not be able to see all the data.

5. Click on Semantic model - Security in this report.

6. Add the role corresponding to Email:

7. Share this report：

8. The user whose report is being shared can only see their corresponding content:

Best Regards,

Liu Yang

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