Forum Discussion
power bi report builder (grouping inside list option)
Hey all!!! how to group table based on specific condition inside list in power bi report builder?
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
10 Replies
In Power BI Report Builder, you group by using an expression in the Group field.
Example:
You want to group values based on a condition inside a list.Steps:
Right-click the table then Row Groups then Add Group then Parent Group
Choose Group by then Expression
Use an expression like this:
=IIF(Fields!Status.Value IN ("A","B","C"),"Group 1","Group 2")
This groups rows where Status is A, B, or C into Group 1, and everything else into Group 2. Another example with numeric condition:
=IIF(Fields!Amount.Value > 1000, "High","Low")
You can also use SWITCH:
=SWITCH(TRUE,
Fields!Score.Value >= 80, "Good",
Fields!Score.Value >= 50, "Average","Poor")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?
Hi 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)
if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.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?
Hi Adarsh_007 ,
I wanted to check if you had the opportunity to review the valuable information provided by Ahmed-Elfeel and Amar_Kumar . Please feel free to contact us if you have any further questions.
Thank you.Hi Adarsh_007
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank youno not yet, since i cannot able to implement the detail section of table into the list of power bi report builder, it showing that only values in a single cell of the table can be depicted. not the detail section.
Hi Adarsh_007 ,
Thanks for reaching out to the Microsoft Fabric Community forum.If you want to work with List in Power BI Report Builder,
Click on insert and then on List and then add it to the canvas.
From Dataset, Drag any of the datafield into the list
Once that is doneGo to Row groups, click on details -> add group -> parent group
That will ensure this window pops up, choose the group by column which is suitable as per your data and then click ok.
Click on Run, you will then get the expected output.
Sample:
I hope this information helps. Please do let us know if you have any further queries.
Thank you
