cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aaron797 Regular Visitor
Regular 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
Microsoft v-lionel-msft
Microsoft

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors