Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Folks,
All I want to do is show the headcount by month as a line chart and then the revenue by month on the same chart as a line to see the trend of headcount versus revenue by month. Why the heck isn't it working?
My data is as follows:
Date | People | Revenue |
Jan-16 | 601 | 429,013 |
Feb-16 | 606 | 435,222 |
Mar-16 | 609 | 433,774 |
Apr-16 | 607 | 441,002 |
May-16 | 619 | 445,799 |
Jun-16 | 633 | 447,529 |
Jul-16 | 638 | 449,442 |
Aug-16 | 643 | 451,815 |
Sep-16 | 637 | 455,573 |
Oct-16 | 649 | 457,381 |
Nov-16 | 658 | 448,980 |
Dec-16 | 663 | 434,386 |
Jan-17 | 668 | 434,174 |
Feb-17 | 665 | 408,879 |
Mar-17 | 655 | 399,544 |
Apr-17 | 625 | 397,531 |
May-17 | 616 | 397,587 |
Jun-17 | 598 | 392,385 |
Jul-17 | 595 | 380,811 |
Aug-17 | 592 | |
Sep-17 | 589 | |
Oct-17 | 584 | |
Nov-17 | 580 | |
Dec-17 | 575 |
All I get are flat lines. I don't want bar charts/line combos. I just want two lines with two Y axes. Left Y axis to be Headcount, Right Y to be Revenue so that I can show correlation. Why is this so complicated? Am I missing a step?
Solved! Go to Solution.
Aside from making a custom visual to suit your particular needs, I suggest using the combo column and line chart.
Proud to be a Super User!
There is no line chart visual with 2 separate y-axes. There is a combo column and line chart that has independent y-axes.
Proud to be a Super User!
Well how do I compare headcount to revenue then with 2 lines? I can't do it because headcount is all the way down at the bottom and revenue is all the way up at the top?
Aside from making a custom visual to suit your particular needs, I suggest using the combo column and line chart.
Proud to be a Super User!
Thanks @KHorseman. Unfortunately, it won't give me the visualization I need. I'll just do it in Excel and paste as an image 🙂
You could perhaps create a measure of your revenue figure divided by 1000 and label it as Revenue ('000) and plot that, that would give you numbers that are much closer together on the same axis which may work.
*blinks* Hmm...That's not a bad idea...I'll try it out! Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |