cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dataguy Member
Member

Column Chart Multiple Measures Group Together By Time Period

Running into the problem if I have Year and Quarter (2016 Q1) or any other legend value where I am not able to have multiple measure values in the Value Section.  

 

 

 

I am able to do this in Excel.   Any ideas how to do this in PowerBI?

 

Capture1.GIFCapture2.GIF

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
dataguy Member
Member

Re: Column Chart Multiple Measures Group Together By Time Period

Xiaoxin, thanks for the response.   I can restructure the data, however coming out of our cube, we have the 3 measures today and I can chart them just fine with a cluster chart in Excel.   I was hoping I wouldn't have to change the data model to make this work in PowerBI.

3 REPLIES 3
Community Support Team
Community Support Team

Re: Column Chart Multiple Measures Group Together By Time Period

Hi @dataguy,

 

You can use clustered column chart to achieve your requirement.

 

Original table:

Capture.PNG

 

Visual:

Capture2.PNG

 

In addition, if your table not contain the legend value field, you can try to use unpivot columns to transfer the original table.

 

Capture3.PNGCapture4.PNG

 

Capture5.PNG

 

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |
Highlighted
dataguy Member
Member

Re: Column Chart Multiple Measures Group Together By Time Period

Xiaoxin, thanks for the response.   I can restructure the data, however coming out of our cube, we have the 3 measures today and I can chart them just fine with a cluster chart in Excel.   I was hoping I wouldn't have to change the data model to make this work in PowerBI.

koenverbeeck Regular Visitor
Regular Visitor

Re: Column Chart Multiple Measures Group Together By Time Period

What if you want to use a stacked column chart instead of a clustered one?

In that case, you can't have multiple measures and a legend at the same time. Excel can.

Blog: sqlkover.com