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

Helper II
Helper II

How to merge second row line to first row, in Paginated Report Builder


I have the following setup

Item No     Category     Direction1     Direction2     Value     Value3

10006        Cat1             Pay                                     100

10006        Cat1                                   Rec                              125

10007        Cat1            Pay                                      98.5   

10007        Cat1                                  Rec                               88.4


How can i show the values for the same item & Category in one row and not have them split into multiple rows.


Any help will be appreciated.


Community Champion
Community Champion

You should apply Grouping on "ItemNo and Category" Columns


Understanding groups in a paginated report - Microsoft Report Builder & Power BI Report Builder | Mi...

Add Grouping to Table Reports in SSRS (

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!

Dear @FarhanAhmed Thank you for the reply, and i did as suggested. Did the grouping based on Item # and Category from the rows tab below the canvas, however the result is still the same. The values are still coming in 2nd row. Tried different combinations for grouping, but didnt work.

Helpful resources

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


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