Drillthrough on a card

[mlee]

Hello,

I have the following sample data set.

ID	Type	Height
1	Door Type A	78.2
2	Door Type B	90.2
3	Door Type A	75.4
4	Door Type B	110.1
5	Door Type C	98.8
6	Door TypeC	75.4
7	Door Type D	110.1
8	Door Type A	110.1

On page 1 of the pbix I have a card visual showing the Max height of the door currently filtered.

If I change the page filters so only Type C doors are shown this visual would show 98.8 instead.

Users would like to see which door(s) are the max height given the current filters on page 1. Ideally they would click on the card and somehow they would see underlying rows of data. In this example if they clicked the card they would the three rows of data that have a max length of 110.10.

Due to space constraints I can't show this table of data on page 1. I'd have to use a drillthrough/bookmark to another page.

I've used drillthrough and it works but only if I use a table visual and not summarize the height column:

I don't really want to show an entire table instead of a card. I could resize the table so it only show a single value but not the ideal.

I couldn't figure out how to drillthrough using the card.

Is it possible to achieve a drillthrough-like functionality with a card?

FYI - we're using page filters exclusively with no slicers on the page.

Thanks,

Mike 

[v-lid-msft · Accepted solution]

Hi @mlee ,

Sorry for that, but we cannot use drill through in card visual, We can use the following workaround if you are using All page filter or Sync Slicer ( sorry we just notice that there is no slicer on your page 1, but all page filters have same effect with sync slicer)

1. create a  table and  two measure

WillShowHighest = SELECTEDVALUE(ShowHighest[Control],FALSE())

Height Visual Control = IF([WillShowHighest],



var h = CALCULATE(MAX('Table'[Height]),ALLSELECTED('Table'))
return IF(h = MAX('Table'[Height]),1,-1)
,1)

2. add a slicer in page 2 as following , save a bookmarks

2. create a sync slicer on page 1 ( or use all page filter)

4. create a button in page 1

6. add a measure in visual filter of page 2

Best regards,

[VasTg]

@mlee 

As far as I know, card doesn't have drillthrough functionality.

If this helps mark it as a solution

Kudos are nice too

[bwarner]

No, you can't use drillthrough on a Card.