https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Create-a-Dynamic-Power-BI-Label-Based-On-Multiple/m-p/787676#M4393 <P>Hello!</P><P>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).</P><P>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.</P><P>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."</P><P>Is it possible to create such a dynamic label?</P><P>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)</P><P>I would also need to create 6 label measures.</P><P>Sales Manager Label = var selectedSalesManager = SELECTEDVALUE('Detail'[SalesManager]) return IF(ISBLANK(selectedSalesManager), "All Managers", selectedSalesManager &amp; "'s Team Detail")</P><P>I'm really hoping there is a way to achieve what I'm after, and I appreciate everyone's help and insight!</P><P>Thank you.</P> Tue, 10 Sep 2019 01:50:31 GMT Keith3618 2019-09-10T01:50:31Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Create-a-Dynamic-Power-BI-Label-Based-On-Multiple/m-p/787676#M4393 <P>Hello!</P><P>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).</P><P>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.</P><P>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."</P><P>Is it possible to create such a dynamic label?</P><P>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)</P><P>I would also need to create 6 label measures.</P><P>Sales Manager Label = var selectedSalesManager = SELECTEDVALUE('Detail'[SalesManager]) return IF(ISBLANK(selectedSalesManager), "All Managers", selectedSalesManager &amp; "'s Team Detail")</P><P>I'm really hoping there is a way to achieve what I'm after, and I appreciate everyone's help and insight!</P><P>Thank you.</P> Tue, 10 Sep 2019 01:50:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Create-a-Dynamic-Power-BI-Label-Based-On-Multiple/m-p/787676#M4393 Keith3618 2019-09-10T01:50:31Z