layer 1 layer 2 layer 3 layer 4 layer 5 abstract shapes

How to group by multiple fields in EasySPC for Power BI

A common question from our EasySPC users

2 min read

EasySPC currently allows up to two fields in the GroupBy well for each visual. This limit helps keep performance acceptable, as adding more fields can dramatically increase the number of data permutations and slow rendering.

However, in some cases, you can work around this limitation by combining two or more fields into a single calculated column — if your data allows it. For example, if you want to group by both Facility and Sub-unit, you can concatenate those into a single field to use as one GroupBy input, leaving the second slot available for another field like Unit Type.

Example DAX

Create a calculated column that combines two fields:

Facility_Subunit_Combined =
[Facility] & " - " & [Subunit]

Then create two DAX measures for use in the GroupBy field well:

GroupBy Measure 1 (based on the combined field):

Facility_Subunit_Filter =
IF(
ISFILTERED('YourTable'[Facility_Subunit_Combined]),
CONCATENATEX(
VALUES('YourTable'[Facility_Subunit_Combined]),
'YourTable'[Facility_Subunit_Combined],
"|"
),
""
)

GroupBy Measure 2 (based on another field, e.g. Unit Type):

UnitType_Filter =
IF(
ISFILTERED('YourTable'[Unit Type]),
CONCATENATEX(
VALUES('YourTable'[Unit Type]),
'YourTable'[Unit Type],
"|"
),
""
)

You can now drag both measures into the GroupBy well. Meanwhile, the individual fields (Facility, Subunit, Unit Type) can still be used separately in slicers and will interact correctly with the EasySPC visual.

More FAQs

Find answers to more common questions from our EasySPC customers

FAQs down down down