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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Keith3618
Frequent Visitor

How to Create a Dynamic Power BI Label Based On Multiple Potential Drill-Through Options

Hello!

I need some help creating a custom Power BI Label [Card Visual]. I have a summary page and a detail page I want to drill-through too. There are three Team Charts on the summary tab that contain a simple Manager-Employee hierarchy. (Sales Team, Distribution Team, and Service Team).

Each record in the detail has a Sales Manager/Employee, Distribution Manager/Employee, and Service Manager/Employee. So I was easily able to set up a drill-through to the detail page for each of my Manager/Employee charts. However, I cannot create a custom label.

When I drill-through on Sales Manager chart, I want the label on the detail page to say "Sales Manager [Name] Detail". When I drill-though on the Service Employee I want the detail page to say "Service Employee [Name] Detail."

Is it possible to create such a dynamic label?

I could theoretically create a detail page for each Team. This would balloon to 6 detail tabs (Sales Manager Detail, Sales Employee Detail, Dist. Manager Detail, Dist. Employee Detail, Service Manager Detail, Service Employee Detail)

I would also need to create 6 label measures.

Sales Manager Label = var selectedSalesManager = SELECTEDVALUE('Detail'[SalesManager]) return IF(ISBLANK(selectedSalesManager), "All Managers", selectedSalesManager & "'s Team Detail")

I'm really hoping there is a way to achieve what I'm after, and I appreciate everyone's help and insight!

Thank you.

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.