Forum Discussion
Line and Stacked Column Chart
I am in a situation where I am needing to illustrate two different line values. One of the line values are much smaller numbers (very close to the values of my columns) and the other is a set of line values that are much larger. This is affecting my lines as I am seeing that i can only have the line values aligned to one side of the y axis or the other.
Is there a way where I can keep both set of values in the line values section and have one set of line values aligned/positioned to the right side of y axis and the other on the left side along with my column value spread.
In the picture below, you can see my Target Value Line (orange) on the very bottom. That value is 1.04 and I am trying to have it related to the values in the left axis.
11 Replies
Anonymous , All the lines would always on the same axis in case online clustered visual, All left or all right.
Anonymous You could fake it 'till you make it. Perhaps you could multiply that value by a multiple like *75000 perhaps? Alternatively you could try for stacked visuals. One other thought, could you maybe add it to the Analytics pane?
Could you explain what you mean by adding it to the analytics pane?
Anonymous
I tried using the analytics pane but only saw the trend line option which was not helpful for my situation.
I am now working on trying to figure out how to multiply the line value by another value such as 75,000. Am i able to do that through report view or will i need to make the calculation in query editor?
Anonymous You could create a measure like:
Measure = SUM('Table'[Column]) * 75000You could use any aggregator function, COUNT, MAX, whatever not sure what you are doing or if you are already using a measure, multiply the end result there by 75000 or Measure = [Old Measure] * 75000
