power bi report builder (grouping inside list option)

[Adarsh_007]

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

[v-nmadadi-msft]

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

[Adarsh_007]

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.

[v-nmadadi-msft]

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

[Adarsh_007]

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

[v-nmadadi-msft · Accepted solution]

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

[v-nmadadi-msft]

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.

[Ahmed-Elfeel]

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:

1. 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)

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

[Adarsh_007]

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?

[Amar_Kumar]

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

1. Right-click the table then Row Groups then Add Group then Parent Group

2. Choose Group by then Expression

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

[Adarsh_007]

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?