Only primary Y-axis shall be colored...
Dear Community,
I like to have a simple combined chart:
- "SALES by PRODUCT CATEGORY" as stacked column on the primary Y-axis
- "MARGIN" as line chart on the secondary Y-axis
So, it should look like this...
...but the PRODUCT CATEGORY (Color drop zone) should only have an effect on SALES, not on MARGIN. So, I want to have ONE line chart for the overall margin.
(How) Is this possible?
THNAK YOU!!!
Micha
4 replies
-
Hey Micha,
One thing you could do to get just one single line for overall margin would be to create a formula for it and use an aggregation block (I used sum, you can use whatever aggregation you need) where the list is All Product Categories and the data point is current member of your date field. Then instead of margin, drag that formula into your Y2 for the line chart.
-
THANKS, , this is what I was looking for!
The legend and the mouse over still are kind of crazy. In fact, there seem to be four margin lines with exactly the same values. In the end it obviously is not possible to define the "Product Category" to be valid only for one of the two measures!
This might be a Feature Request...
-
I see what you mean - here's a different approach that should cover both the legend and the data points. Basically, create a formula for each - so Accessories Sales, Bike Sales, Clothing Sales, Component Sales. Add them one by one, to Y1 > Stacked Column Chart > All. Then, we can remove Product Category from colors and keep our Margin measure on Y2 as a line chart. Since they are all measures of their own, we can control the color through the formatting panel or Right click > Edit on the legend.
-
- ah, yes of course: Good idea, this should work!
THANK YOU again, Brendan!
-
