Skip to main content
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

Helper II
Helper II

How to Create section/Group in Paginated Report ( Report Builder)

Hi All, 


I have a question on Power BI Report Builder where I am trying to create a paginated report and I have a requirement as below.

Lets say I have a report output as below... table.




Now I want to convert above table group by Year Id and result would be as below in Paginated Report. Is it Possible? if Yes, how to achieve it.  Your help would be appreciated it.  Thank you.



Helper II
Helper II

Hi Eyelyn, Thank you for replying my question. I will try to crate using slicer visual and let you know if I am abel to achive the result I wanted to. I will keep you posted. Thank you.

Hi @Patv ,


Any luck with this requirement in Power BI report builder? I have a similar requirement and would be great if you can share your solution.




Hi Ganesh, 

I did not find any solution on this.

Community Support
Community Support

Hi @Patv ,


Did you try to drag the Year ID column to a Slicer visual ? Slicers are a great choice when you want to:

  • Display commonly used or important filters on the report canvas for easier access.
  • Make it easier to see the current filtered state without having to open a drop-down list.
  • Filter by columns that are unneeded and hidden in the data tables.
  • Create more focused reports by putting slicers next to important visuals.

Power BI slicers don't support:

  • Input fields
  • Drill-down options


More information about Paginated Reports:

A Step-by-Step Overview of Paginated Reports in Power BI



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

Helpful resources

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.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors