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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Chitemerere
Responsive Resident
Responsive Resident

Dynamic Title with Drill through and Two Visuals

I have two map visuals which i want to use drill through to.  The visuals are as folows:

SampledCountry.JPG

The second visual is as follows:

SampledPlace.JPG

 I then want to drill to the same detail page and be able to change the title of the detail page using the report title measure which as shown below:

Sample detail page1.JPGThe above is the result for the country drill through.  The title does not give the name of the country.  The drill through for the place gives the following:

 Screenshot 2020-05-17 at 21.42.29.png

The place title gives the details of the place unlike the country drill through.

 

How can i change the report title measure to work with both the selected country and place drill through?

 

Best regards,

Chris

 

 

3 REPLIES 3
AllisonKennedy
Super User
Super User

I think the variable might be part of the problem. 

 

Try this: 

 

Sample Analysis Details All = IF(HASONEVALUE(DimRegionNew[PlaceSampled]), SELECTEDVALUE(DimRegionNew[PlaceSampled]) & " Sample Analysis Detail Page", SELECTEDVALUE(DimCountry[Country]))

 

 SELECTEDVALUE( ) has two arguments, but we're only using 1 of them, so if you get BLANK returned, it might mean that there is more than one value selected for Place. 

 

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

 

If you found this post helpful, please give Kudos.

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 

https://sites.google.com/site/allisonkennedycv


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Many thanks, just added the string after the SELECTEDVALUE(DimCountry(Country)) and it worked.

 

Best regards,

Chris

Thank you very much for your prompt assistance, most appreciated.  It is a better solution than what i had, but not final.  The results are as follows:

SampledCountry.JPG

 

The string title is missing unlike for the place result as shown below:

 

SampledPlace.JPG

 

Any improvement that can be made?

 

Regards,

Chris

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors