Hi All,
I am very new to Power BI and looking for your help here !
I have applied RLS to my dashboard using USERPRINCIPALNAME ()
There are 5 columns that I am using in the RLS to search for USERPRINCIPALNAME (). This works fine for me as I am using OR function to apply the RLS. Below mentioned is the function used in RLS.
[ManagerEmail2] = USERPRINCIPALNAME()||[ManagerEmail3] = USERPRINCIPALNAME()||[ManagerEmail4] = USERPRINCIPALNAME()||[ManagerEmail5] = USERPRINCIPALNAME()||[ManagerEmail6] = USERPRINCIPALNAME()
The issue I am facing is with the dynamically change the chart X axis based on the RLS result column. For example if the logged in user email ID is found in Column "[ManagerEmail5]" then I want to change the chart X axis to [ManagerEmail6]. Is this possible in Power BI ? Below is the sample data from my Table.
If I have to do this in SQL server, I can use IF statement in a custom column to change the respective Column values to display. If (USERPRINCIPALNAME () in [ManagerEmail2] , [ManagerEmail3], If (USERPRINCIPALNAME () in [ManagerEmail3] , [ManagerEmail4], If (USERPRINCIPALNAME () in [ManagerEmail5] , [ManagerEmail6], Blank())
| emp_full_name | ManagerEmail2 | ManagerEmail3 | ManagerEmail4 | ManagerEmail5 | ManagerEmail6 |
| TN | GA@JJ.com | JL@JJ.com | UN@JJ.com | JK@JJ.com | DC@JJ.com |
| WQ | GA@JJ.com | JL@JJ.com | UN@JJ.com | JK@JJ.com | DC@JJ.com |
| DS | GA@JJ.com | JL@JJ.com | UN@JJ.com | JK@JJ.com | GR@JJ.com |
| DA | GA@JJ.com | JL@JJ.com | UN@JJ.com | JK@JJ.com | r@g.com |
| DC | GA@JJ.com | JL@JJ.com | UN@JJ.com | JK@JJ.com | DC@JJ.com |
| VN | GA@JJ.com | JL@JJ.com | UN@JJ.com | JK@JJ.com | VN@JJ.com |
| TM | GA@JJ.com | JL@JJ.com | UN@JJ.com | JK@JJ.com | DC@JJ.com |
| JK | GA@JJ.com | JL@JJ.com | UN@JJ.com | JK@JJ.com | JK@JJ.com |
| JK2 | JK@JJ.com | JK@JJ.com | JK@JJ.com | JK@JJ.com | JK@JJ.com |
| LP | GA@JJ.com | JL@JJ.com | UN@JJ.com | JK@JJ.com | LP@JJ.com |
| RA | GA@JJ.com | JL@JJ.com | UN@JJ.com | JK@JJ.com | DC@JJ.com |
| KV | GA@JJ.com | JL@JJ.com | UN@JJ.com | JK@JJ.com | KV@JJ.com |
