Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

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

visualization.png

 

The Data Table (view of a sql server)

data.png

 

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

 

Thank you

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

Hi Xiaoxin,

thank you, that worked very well.

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

Cheers, Michel

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors