Sharing and access control in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows users, their roles, and their access levels for a Power BI report.

Cell	Value
A1	User
B1	Role
C1	Access Level
A2	Bob
B2	Contributor
C2	Edit
A3	Alice
B3	Viewer
C3	Read
A4	Carol
B4	Admin
C4	Full Control

Formula Trace

IF(B2="Admin", "Full Control", IF(B2="Contributor", "Edit", "Read"))

Step 1: B2="Admin"

Step 2: B2="Contributor"

Step 3: IF(TRUE, "Edit", "Read")

Cell Reference Map

    A       B           C
1 | User  | Role      | Access Level
2 | Bob   | Contributor -> Formula uses B2
3 |       |           |
4 |       |           |

The formula references cell B2 to determine Bob's role and assign the correct access level.

Result

    A       B           C
1 | User  | Role      | Access Level
2 | Bob   | Contributor | Edit
3 |       |           |
4 |       |           |

The formula result for Bob's access level is 'Edit' because his role is Contributor.

Sheet Trace Quiz - 3 Questions

What access level does a user with the role 'Admin' get according to the formula?

A Edit

B Full Control

C Read

D No Access

Key Result

IF(role = "Admin", "Full Control", IF(role = "Contributor", "Edit", "Read"))