cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

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
Helper III
Helper III

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.

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

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
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper III
Helper III

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.

View solution in original post

Highlighted
Advocate II
Advocate II

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

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors