topic Re: power bi report builder (grouping inside list option) in Developer

power bi report builder (grouping inside list option)

Adarsh_007 — Wed, 24 Dec 2025 10:35:10 GMT

Hey all!!! how to group table based on specific condition inside list in power bi report builder?

Re: power bi report builder (grouping inside list option)

Amar_Kumar — Wed, 24 Dec 2025 18:30:01 GMT

@Adarsh_007

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")

Re: power bi report builder (grouping inside list option)

Ahmed-Elfeel — Fri, 26 Dec 2025 01:37:42 GMT

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):

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.

Re: power bi report builder (grouping inside list option)

v-nmadadi-msft — Mon, 29 Dec 2025 03:41:28 GMT

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.

Re: power bi report builder (grouping inside list option)

v-nmadadi-msft — Fri, 02 Jan 2026 05:34:43 GMT

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 you

Re: power bi report builder (grouping inside list option)

Adarsh_007 — Fri, 02 Jan 2026 11:23:27 GMT

no 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.

Re: power bi report builder (grouping inside list option)

Adarsh_007 — Fri, 02 Jan 2026 11:26:36 GMT

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?

Re: power bi report builder (grouping inside list option)

Adarsh_007 — Fri, 02 Jan 2026 11:28:14 GMT

Re: power bi report builder (grouping inside list option)

v-nmadadi-msft — Mon, 05 Jan 2026 11:57:49 GMT

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 done

Go 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

Re: power bi report builder (grouping inside list option)

Adarsh_007 — Mon, 05 Jan 2026 12:04:47 GMT

can we add a table with details row in it inside the list? and then can we apply "group by" over rows of the table.?

Re: power bi report builder (grouping inside list option)

v-nmadadi-msft — Wed, 07 Jan 2026 05:13:02 GMT

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