Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Thank you in advance for any help!
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |