Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have setup a page for each KRA (Finance, Facility and Equipment, Stakeholders etc), and have linked the field "KRA is Finance" in the drill through on the finance page.
I am trying to setup drill through for my chart, currently, when you right click "Finance - Drill through" in a chart, it comes up with all the different KRAs, when you click finance, it will successfully take you to the finance page, however if you right click finance, and go to KRA: Employee the table will be blank.
How to I tidy this up, Ideally, when right clicking "Finance - Drill through" only the finance report should come up. etc.
Hi @aaron797 ,
This happens because you create multiple pages and add the KAR field to 'drillthrough bucket' of each page:
You can only keep two pages.
Or create measures for each page and use the measure instead of KAR column:
// use the measure insteading of KAR column, including value bucket and drillthrough buctet.
Measure 2 =
CALCULATE(
SUM([Value]),
FILTER(
Sheet3,
[KRA] = "Finance"
)
)
Measure 3 =
CALCULATE(
SUM([Value]),
FILTER(
Sheet3,
[KRA] = "Facility and Equipment"
)
)
Measure 4 =
CALCULATE(
SUM([Value]),
FILTER(
Sheet3,
[KRA] = "Stakeholders"
)
)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |