Forum Discussion
Report name
- 2 months ago
Hi Peter_23
There isn't a native DAX function like REPORTNAME() that can dynamically read the tab or report name, but you can achieve this behavior using a couple of workarounds depending on how you structure your file.
If "Report A" and "Report B" are separate pages inside the same PBIX file, the easiest trick is to use page-level filters or a disconnected navigation table. You can create a small disconnected table containing your page names, use that table to build a custom navigation menu or slicer, and then use SELECTEDVALUE() in your measure.
Alternatively, you can hardcode a specific measure on each individual page to identify it, or use the Page Name option found in the standard page navigator visual conditional formatting settings to dynamically capture where the user is looking.
If "Report A" and "Report B" are completely separate report files published to the Power BI Service that share the same semantic model, you can use the USERPRINCIPALNAME() or CUSTOMDATA() functions to pass environmental context, but the most robust method for separate reports is to simply use a localized table or parameter in each specific PBIX file before publishing.
Hi Peter_23
There's no DAX function for this yet, it's actually a long-standing feature request on the Power BI Ideas forum with a lot of votes but still no implementation. The only practical workaround is to create a what-if parameter or a simple DAX measure with a hardcoded value per report:
Report Name = "Report A"Not elegant, but it works. The measure then travels with that specific report and you can use it in any visual or dynamic title.
If this is something you need across many reports it's worth upvoting the idea here: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=9b0aed22-be8a-4483-af35-c91b8fe0b79e