How do I create a drillthrough for this?

[pborah]

Hi there,

Below is a sample of our employees' company phone usage charges info - 

This data is straight from the network carrier we use for our company phones.

Any of the charges you see e.g. data, roaming, etc are for going over the alloted limits (excess) for each company phone.

I want to make a report that shows the total of these excess charges for each category - data, text roaming, international calls, etc. on the main page of the report -

and then I want the user to be able to drillthrough on these totals which will take them to the individual users with excess charges for each respective category like so -

But I have not been able to make the drillthrough part work.

Is this possible? Thank you very much.

[amitchandak]

@pborah , In the recent version of Power BI you can drill from card visual. Add the measure to the list of drill through on the drill through Page

[pborah]

@amitchandak that didn't work. E.g. I created a measure a bunch of to calculate total data charges. The drill through works but when you scroll down the list, it still shows all users as opposed to only the users who have excess data charges. Thank you.