Grouping in legend and stacked column chart

[Anonymous]

Hello,

I have the following "Error codes" table loaded in Power Query.

Date	Error code
03/01/2021	FS
03/01/2021	FS
04/01/2021	FS
04/01/2021	PO
04/01/2021	RO
04/01/2021	RO
05/01/2021	RO
05/01/2021	RO
08/01/2021	AD
08/01/2021	AD
08/01/2021	WO
08/01/2021	WO
10/01/2021	FP
10/01/2021	FP
11/01/2021	FP
11/01/2021	PO
11/01/2021	PO
11/01/2021	PO
13/01/2021	PO
13/01/2021	WO
13/01/2021	WO
13/01/2021	WR
14/01/2021	GS
14/01/2021	PD
14/01/2021	PD
14/01/2021	PO
14/01/2021	PO
15/01/2021	GS
17/01/2021	GS
18/01/2021	WR
18/01/2021	WR
19/01/2021	FT
20/01/2021	GF
20/01/2021	GF

I created the following stacked column chart using the above table:

The problem is that i am trying to group the error codes (all the codes in a group should be the same colour) and then show the descriptions instead of the error codes in the legend:

• Tips (FF, FP, FS & FT)
• Tricks (TC, TN, TD & TM)
• Games (AD, AF, AS, PE & CC)
• Keys (WO, WR & WT)
• Scan (RO)
• Tech (IT)
• Recycle (PP)
• Reboot (PD,PO & PX)
• Ready (GF & GS)

Any help is much appreciated!

[johncolley]

Hi @Anonymous ,

You can use grouping to do this: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning then use the new grouping column in the legend.

[Anonymous · Accepted solution]

OK, i managed to solve it by researching and learning about grouping: https://www.youtube.com/watch?v=h_RG4GYqcws

I decided to share the solution instead of just deleting this thread since it could be helpful to others who encounter the same issue.