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.
I have two map visuals which i want to use drill through to. The visuals are as folows:
The second visual is as follows:
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:
The 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:
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
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
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:
The string title is missing unlike for the place result as shown below:
Any improvement that can be made?
Regards,
Chris
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |