Add multiple columns as X axis in stack column chart

Hi Anonymous ,

Please check the following step as below.

1. Unpivot the table in power query. Please check the M code for your reference.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUXIvyi8tUDAEskAoVidayQnChkgYwUSdsap1warWFaoCJmEMFnXDNCEWAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Emp = _t, #"Group 1" = _t, #"Group 2" = _t, #"Group 3" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Emp", type text}, {"Group 1", type text}, {"Group 2", type text}, {"Group 3", type text}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {}, "Attribute", "Value"),
    #"Filtered Rows" = Table.SelectRows(#"Unpivoted Columns", each ([Attribute] <> "Emp"))
in
    #"Filtered Rows"

2. Then create a measure as below and add it to the line chart to get the result as we need.

Measure = CALCULATE(COUNTROWS('Table1 (2)'),FILTER('Table1 (2)','Table1 (2)'[Value]<>BLANK()))

Please check the pbix as attached.

Regards,

Frank