Question

A retail analyst has a clustered column chart showing sales by Product Subcategory. There are 40 subcategories, making the chart cluttered and hard to read. Management wants to see sales rolled up into three meaningful groups — 'Apparel', 'Electronics', and 'Home' — that each combine several existing subcategories, but the underlying data has no such grouping column. The analyst wants the fastest solution that requires no changes to the source query or data model tables. What should the analyst do?

Accepted Answer

Select the relevant subcategory data points on the chart, right-click, choose Group data, and repeat to build the three custom groups, then place the new group field on the axis.

Answer

Add a conditional column in Power Query that maps each subcategory to a group name and reload the model.

Answer

Create a DAX calculated table that summarizes sales by a manually defined group key.

Answer

Apply binning to the Product Subcategory field to reduce the number of categories displayed.