Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
shjaffer
Frequent Visitor

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 3
dixityashovardh
Frequent Visitor

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

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. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

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

Is that possible?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.