The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I have a dashboard with two pages. In the first page there is a top level view of employee performance.
This page has many visualisations and one of them is a table like below :
Employee | Wokring days | Hours | Output |
A | 25 | 187.5 | 502 |
B | 27 | 202.5 | 506 |
C | 25 | 187.5 | 513 |
In Page 2 there is detailed employee performance dashboard.
What i want to achieve: When I select employee A on the visualisation in Page 1 , Page 2 is automatically filtered and shows detailed performance of Employee A.
I read some articles online but did not quiet relate to something like this. Could someone assist? Thank you
You create a drillthrough target page (ie Page 2) that indicates it can receive the Employee field for drillthrough. Then on Page 1 you right click on employee A and follow the Drillthrough click path.
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |