- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Displaying text in a matrix calendar
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?
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
59 | |
54 | |
54 | |
36 | |
33 |
User | Count |
---|---|
81 | |
69 | |
45 | |
45 | |
43 |