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