Reply
Karolina_95
Frequent Visitor
Partially syndicated - Outbound

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   
Day1234
Employee    
Lady GagaVV  
Janet Jackson S SD

 

Overview over approvers vs Employees

EmployeeAprover
Lady GagaLewis Hamilton
Janet JacksonLewis Hamilton
MadonnaBono

 

Reason for being absent Letter 
SickS
Vacation

 

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?

1 ACCEPTED SOLUTION
avatar user
Anonymous
Not applicable

Syndicated - Outbound

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.

vyangliumsft_0-1702348574043.png

2. Joins the relationship between two tables:

vyangliumsft_1-1702348574045.png

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

vyangliumsft_2-1702348588231.png

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.

vyangliumsft_3-1702348588232.png

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

vyangliumsft_4-1702348605076.png

6. Add the role corresponding to Email:

vyangliumsft_5-1702348605077.png

7. Share this report:

vyangliumsft_6-1702348622853.png

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

vyangliumsft_7-1702348622854.png

 

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.

View solution in original post

1 REPLY 1
avatar user
Anonymous
Not applicable

Syndicated - Outbound

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.

vyangliumsft_0-1702348574043.png

2. Joins the relationship between two tables:

vyangliumsft_1-1702348574045.png

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

vyangliumsft_2-1702348588231.png

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.

vyangliumsft_3-1702348588232.png

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

vyangliumsft_4-1702348605076.png

6. Add the role corresponding to Email:

vyangliumsft_5-1702348605077.png

7. Share this report:

vyangliumsft_6-1702348622853.png

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

vyangliumsft_7-1702348622854.png

 

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.

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

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.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)