cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ymobbs
Helper I
Helper I

If you want to add "Column series", there should be only one field in Column value?

Hello,

 

I have this line and stacked column chart set up. See below:

 

I have two fields in "Column values", "Actual Volume" and "Backlog Volume". (My actual volume is from the past from table A and my backlog volume is from the future months in table B.) I want to add "Product Category" in the "Column series", but it doesn't allow me to drag "Product Category" field into "Column series". 

 

I tried to delete one column value and only kept one, then the system allowed me to drag "Product Category" field into "Column series". 

 

Is it set up that way --- if you want to add "Column series", there should be only one field in Column value? If not, how can I add "Product Category" in the "Column series" with two fields in Column values? 

 
 
 

12345.PNG

 

Thank you in advance for any help!

 

 

1 ACCEPTED SOLUTION
dax
Community Support
Community Support

Hi ymobbs, 

It seems to be the design. When you have two values in column value, it will show legends based on two fields instead of Categories or column series(so you can't add field in series ). When you have one field in column value, then the chart will show legend based on column series. I think this is by design.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
dax
Community Support
Community Support

Hi ymobbs, 

It seems to be the design. When you have two values in column value, it will show legends based on two fields instead of Categories or column series(so you can't add field in series ). When you have one field in column value, then the chart will show legend based on column series. I think this is by design.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors