Forum Discussion
Line and column chart, Line one two axis
It appears there is currently no way to do this in PowerBI
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)
Hi nrahn,
Sorry but at first I didn't understood wht you needed, Again the questions is the range of values that you use for you information, if your chart was only Clustered columns you add the option to add analytics to it, check this link: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-analytics-pane/
However the type of chart you chose only gives trend lines not averages, again I believe that the question you have is related with the difference between your two averages.
Even in excel this would go trough several change in the "standard" charts and selecting wich type of charts correspond to each series of data.
In my opinion the best way would be to separe both visuals doing a visual with the Realization and adding the trend line average and another with realization, ormaybe put the average value or realization in a separate card visual.
For me as a end user it's confusing to have to axis with different scales in all of my years making reports and preparing charts, I have always tried to have the information in the same format in order to have it comparable, it's one of my best practices.
Regards,
MFelix