Drill through Multiple Values

[aaron797]

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.

 

[v-lionel-msft]

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.