Forum Discussion
Split Calculation Items of a Calculation Group into Column Y-Axis and Line-Y-Axis
I have created a Time Intelligence Calculation Group that contains 3 Calculation Items, 2 of these items calculates the SUM of a measure for This Year and SamePeriod Last Year and the 3rd item calculates the (Growth) % difference between the two.
I am trying to create a Line and Clusterd Column Chart Visual, with This Year and Last Year calculations that show up as the columns and the Growth% as the line.
Currently all 3 calculation items show up as columns in the visual.
2 Replies
- MFelix
Super User
Hi crispy_sam ,
Since you are adding the Calculation group in the legend it will calculate over the columns so it will split into 3 columns.
My advice is for you to create a second measure to add the growth to the line values since the lines are independent from the legend.
If you pay attention to the chart option when you add the legend you won't be able to add more values to the Y-Axis but you can use others to the lines y-axis.
This would work, but i would have to create multiple independent measures for growth based on the different mertics (Sales, COGS, etc) I would need to calculate on.
Or is there an easier way of doing it?
