Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi Everyone,
I have a table ( Table1 ) like below and I have 3 slicers Proposed, Developed, Approved.
I need to show complete data when any user looged in, but when he clicks on Approver he needs to see only the data where he is in Proposed.
Ex- If Kevin logged in, he will see the complete data(Table 1), when he clicks on Proposed slicer he needs to see only Project1 and Project 3 where he Proposed ( Table 2 )
Table 1 -
| Domain | Project | Proposed | Developed | Approver | Status |
| Domain1 | Project 1 | Kevin | Mark | John | Completed |
| Domain 1 | Project 2 | Nick | Kevin | Stevin | In progress |
| Domain2 | Project 3 | Kevin | Stevin | Marcus | Draft |
| Domain2 | Project 4 | John | Nick | Stevin | Overdue |
| Domain3 | Project 5 | Marcus | Stevin | Kevin | Completed |
| Domain3 | Project 6 | Mark | Kevin | Kevin | Draft |
Table 2 -
| Domain | Project | Proposed | Developed | Approver | Status |
| Domain1 | Project 1 | Kevin | Mark | John | Completed |
| Domain2 | Project 3 | Kevin | Stevin | Marcus | Draft |