bar chart grouped by a column detailed by an other column while sum the value of a third column

[Anonymous]

Hi,

i am complete Power Bi newbee, but have a fair amount of experience in coding and also sql.

I try to create a bar chart that has a common axis of a column (state). Each state should be detailed into metrics which are again in a column of the same row. The value of the metric(s) are calculated by summing up a column (Value) of all rows that match the first two criterias (state and metric). I hope I could explain my goal properly 🙂

The desired visualization

The Data Table (view of a sql server)

I cant find a post, tutorial or any other source of help. Thus I would appreciate your help or hints very much.

Thank you

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

You can create a chart with state as axis, metric to legend, value to value field with summary mode 'sum'.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Xiaoxin,

thank you, that worked very well.

Although I needed to delete my original chart and setup an new one, whyever ...

Cheers, Michel