Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn 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 |
| User | Count |
|---|---|
| 20 | |
| 18 | |
| 11 | |
| 9 | |
| 7 |
| User | Count |
|---|---|
| 42 | |
| 38 | |
| 21 | |
| 18 | |
| 17 |