Is there a way to reflect multiple values on the y axis? For example, I want to plot a line graph for the amount of of clicks and impressions (which is in the hundreds and thousands) along with our Conversion rate (e.g. 2%). When plotting the clicks and impressions with a % in the same graph, my Conversion rate line is almost invisible/flat because it's so small. I am already using the Log scale. I tried changing the display (thousands, billions) but it did not change my graph at all.
Is there another method so I can see my data more proportionally?
@jewelry Yes you can have a secondary Y-Axis
See my response here => http://community.powerbi.com/t5/Desktop/Force-second-y-axis/m-p/25015#M8165
In excel you can specify a second axis to get around this problem, I dont think PBI has this functionality yet though.
One workaround (and its not the greatest) would be to create a second seperate chart and overlay it on top off the first. If you turn off the background and labels etc you can get it to show just the line
2 lines is not possible, but combination of line and column is possible: "Line and cluster column chart" is the answer. It's one of the newer standard-charts:
Especially in Power BI I advise you NOT TO overlay charts. Pure mess, trust me. 😮
@Bjoern agree with the sentiment of not overlaying, I was scraping the barrel for a solution as when I looked at the visualisation you suggested I couldn't see a way to adust the two seperate y axis independantly so assumed the same scaling issues.
Would love MS to add duel Axis and also option to invert axis for rankings etc where 1 needs to be at the top.
Yes, truely, the options would be unlimited. I am still dreaming of a "dynamic" axis which can be cut off dynamically, e.g. just showing an interval between 50 and 100 based on the values. Would be the same like the min() max() functions, which can be used in excel. By doing this, charts could be combined etc ... ah, imagine the possibilities.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.