Forum Discussion
Define table cell by cell
- 5 years ago
Hi Anonymous
A common practice is to group the original CUSTOMER values into several groups by creating a new group column, and use this group column in a table or matrix visual. Download the attachment for details.
You could use below DAX codes to create a group column. Modify it per your need.
Groups = SWITCH ( 'Table'[TYPE], "A", IF ( 'Table'[CUSTOMER] IN { "1", "2" }, 'Table'[CUSTOMER], "Rest of Customer Type A" ), "B", IF ( 'Table'[CUSTOMER] IN { "5", "6", "7" }, 'Table'[CUSTOMER], "Rest of Customer Type B" ) )Or you could also right click on CUSTOMER column and select New group. Use grouping and binning in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Hi Anonymous
A common practice is to group the original CUSTOMER values into several groups by creating a new group column, and use this group column in a table or matrix visual. Download the attachment for details.
You could use below DAX codes to create a group column. Modify it per your need.
Groups =
SWITCH (
'Table'[TYPE],
"A",
IF (
'Table'[CUSTOMER] IN { "1", "2" },
'Table'[CUSTOMER],
"Rest of Customer Type A"
),
"B",
IF (
'Table'[CUSTOMER] IN { "5", "6", "7" },
'Table'[CUSTOMER],
"Rest of Customer Type B"
)
)
Or you could also right click on CUSTOMER column and select New group. Use grouping and binning in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.