Forum Discussion

shjaffer's avatar
shjaffer
Frequent Visitor
9 years ago

Display Drill path

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

3 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    9 years ago

    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's avatar
      shjaffer
      Frequent Visitor
      9 years ago
      The original message said County-> City-> Office.

      Is that possible?
  • dixityashovardh's avatar
    dixityashovardh
    Frequent Visitor
    8 years ago

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