Display Drill path

[shjaffer]

Hello

I have a bar chart that drills down from County -> City -> Office.  The drill down works perfectly.  I want to be able to display on a label or the chart header which City I am displaying the Offices for.

Is this possible?

I saw a blog about using Filters and custom labels...but I want to use drilling.

thanks

SJ

[dixityashovardh]

Hi, Just wanted to check if you ever got a solution to this problem. I need to display the same information.

[MattAllington]

If it is just city (as you say), then you can write this measure. 

=concatonatex(values(TableName[City]),tablename[City],", ")

you can add this measure to a card and it should show which cities are currently filtered. 

[shjaffer]

The original message said County-> City-> Office.

Is that possible?