Forum Discussion

GRedhead's avatar
GRedhead
Icon for Helper I rankHelper I
4 years ago
Solved

Group Columns in Stacked Column Chart

Hi, Does anyone know how I can group the following columns? If I look at the data in a table I see the same Year and Qtr the same Case Type and want to sum the cases. But for some reason, I cannot...
Need Help
  • GRedhead's avatar
    GRedhead
    4 years ago

    Hi, i think we have worked it out, it appears to be because of the sort on the Year & Qtr column, it was on the month sort order but when we switch it to itself the column displays as I expected, a bit weird.

sanalytics's avatar
sanalytics
Icon for Super User rankSuper User
4 years ago

GRedhead 

 

You can grouped the data in Power Query.Below are the steps

let
Source = Source,
#"Grouped Rows" = Table.Group(Source, {"Year qtr", "CaseType"}, {{"Count", each List.Sum([Count]), type nullable number}})
in
#"Grouped Rows"

 

Hope this will help you

 

Regards

sanalytics