cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aaron797 Frequent Visitor
Frequent Visitor

Drill through Multiple Values

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.

 image.png

image.png

1 REPLY 1
v-lionel-msft Senior Member
Senior Member

Re: Drill through Multiple Values

Hi @aaron797 ,
This happens because you create multiple pages and add the KAR field to 'drillthrough bucket' of each page:

b1.PNGb2.PNG

 

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.

 

 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)