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
BradRose
Helper I
Helper I

Power BI Report Builder Header

Good Afternoon:

 

In Power BI report Builder I want to use the "As of Date" which comes from one of my data sources in the header.  I only see the option to add a Text Box not a Table in the Header.  How can Show the Object from my data set in my Header so it repeats on each tab along with the header when exporting?

 

Thanks

 

Brad

1 ACCEPTED SOLUTION
v-yingjl
Community Support
Community Support

Hi @BradRose ,

I'm not certain whether I understood what you mean correctly by these steps:

  1. Right-click the row, column, or corner handle of a tablix data region, and then click Tablix Properties.

  2. In Row Headers, select Repeat header rows on each page.

  3. Click OK.

You can also refer the following microsoft document and case:

  1. Report header document 
  2. Report header case 

If above not help, could you please share some scrrenshots or expected output for further help?

 

Best Regards,
Yingjie Li

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

View solution in original post

3 REPLIES 3
BrianD
Regular Visitor

Hi,

 

I have added a table to Power BI Report Builder and the data is extending over a number of pages. I right clicked on the table headings and clicked tablix properties and clicked Repeat Header rows on each page, Keep header visible while scrolling, repeat header columns on each page, keep header visible while scrolling however the headings on the table do not appear on subsequent sheets.

 

Is there a solution to allow table headings show on multiple sheets. 

v-yingjl
Community Support
Community Support

Hi @BradRose ,

I'm not certain whether I understood what you mean correctly by these steps:

  1. Right-click the row, column, or corner handle of a tablix data region, and then click Tablix Properties.

  2. In Row Headers, select Repeat header rows on each page.

  3. Click OK.

You can also refer the following microsoft document and case:

  1. Report header document 
  2. Report header case 

If above not help, could you please share some scrrenshots or expected output for further help?

 

Best Regards,
Yingjie Li

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

Hi Yingie:

 

I am able to use a rectangle instead of a table to acheive the desired result.

 

Brad

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