Forum Discussion
Line and column chart, Line one two axis
It appears there is currently no way to do this in PowerBI
You are correct but this will not work for my solution as the data realistically could be as separate as they are. Columns and total avg in the -% while the margin above +50%. turning off the secondary changes the chart to look like the below.
Did you try use the star and end to reset the size of you two Y-axis
yes even when changing to my min of realization (-.018 and max of margin (.63) the columns are discernable from each other
What kind of result you need or want? Because since your data as so much variance between the positive and negative using a single Y-Axis will always give you this chart.
as stated in the original post I want to convert the Total Average Realization field to a line on the same axis as the realization column.
Left Axis (Realization%) (-)2% - 0%
-Realization (column)
-Total Average Realization (line)
Right Axis (Margin %) 60%-63%
-Margin % (line)