Forum Discussion
power bi report builder (grouping inside list option)
Hi Adarsh_007 ,
You can add the table inside the List using this method:
Click inside the List.
Then right click inside the List area.
Choose Insert Table and drop the table directly inside the List container.
Thank you
Super UserHi Adarsh_007,
I hope you are doing well today ☺️❤️
So to group rows in your Table (Tablix) based on a condition inside a List you need to:
Insert Your Table Inside the List
Drag a List control into your report body.
Bind it to a dataset (your main dataset)
Drag a Table into the List (this is where you will show the rows detail)
Add the Group to the Table
Right click on the table > Row Groups area > Add Group > Parent Group
In the Group by expression box enter a conditional expression (that defines how you want to group records) like:
=IIF(Fields!Status.Value IN ("A","B","C"), "Group 1", "Other Groups")- Finally run or preview your report to confirm that the table data is grouped correctly based on the condition you specified
Microsoft Learn Resources (More Detailed Than Me):
- Group expression examples in paginated reports (Power BI Report Builder)
- Add or delete a group in a data region in a paginated report (Power BI Report Builder)
I tried to add the table inside the list of the power bi report builder, for me it's showing that detail section (i.e where data is populating below headers of the table) can't be supported inside the list. Can you help me in knowing whether it is possible or not and if yes then how?