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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
v-sabgup
Employee
Employee

Is IT possible to get the report page name by using DAX

Hi All

 

Is there is any way to get the Page Name via DAX.

 

Reason for this ask : At present we are displaying the Read me count for all the pages which discribe about the page information. 

 

Problem Statement : In case of any new pages is added to the report we need to modify the DAX by adding a condition.

 

 

Solution Required : If we can able to get the page name via DAX then we dynamically pass the pagename in the filter and that will reduce our manual changes and it will me more useful.

 

As per the requirment i want to diplay some business content which describe about the page. Which help the user to understand about the page and how the business is running. To acheive that we are using a DAX to display information.

 

DAXForloadingPlaceholder =
var test = CALCULATE(distinct(Sheet1[Placeholder]),FILTER(Sheet1,Sheet1[Tabname]="A1"))
var userName1=USERPRINCIPALNAME ()
var salesAmount=sum(Sheet2[Sales])
var test1 = SUBSTITUTE(test,"DAX1",userName1)
var test2=SUBSTITUTE(test1,"DAX2",salesAmount)
var test3=SUBSTITUTE(test2,"DAX3",year(TODAY()))
var test4=SUBSTITUTE(test3,"DAX4","Sales Team")
return test4
 

We have build a similar information by passing filter as hardcoded value . 

For a demo

vsabgup_0-1651045058428.png

 

 

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

Hi @v-sabgup ,

 

This requirement seems a bit specific, I don't think you can get the name corresponding to the REPORT by creating a dax in the powerbi desktop, which doesn't have much of a real business scenario.


However, if the report is published to the service, you can get the information about the report through the rest api, and one of the parameters is the report name.

for example:

GET https://api.powerbi.com/v1.0/myorg/reports/879445d6-3a9e-4a74-b5ae-7c0ddabf0f11/pages

vhenrykmstf_0-1650954533533.png

 

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k
Super User
Super User

@v-sabgup not really clear what you are looking for? Any example/screenshot will help to understand the problem.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.