Graph Showing both Revenue by against and Total Company Revenue

[kc_]

Hi All - I am trying to achieve the below in PowerBI - can anyone assist?

In essence, I would like to display the revenue of each customer against the company total revenue.

Many thanks

[Anonymous · Accepted solution]

Hi,lbendlin ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Hello,@kc_ . I am glad to help you.
Like this?
I hope my test below will help you

I have created several measures to calculate the total revenue of the company for each month and the corresponding revenue for each employee.

IncomeALL = SUM('Test'[InCome])

Income_A = CALCULATE(SUM(Test[InCome]),'Test'[CustomerName]="Customer A")

Income_B = CALCULATE(SUM(Test[InCome]),'Test'[CustomerName]="Customer B")

Income_C = CALCULATE(SUM(Test[InCome]),'Test'[CustomerName]="Customer C")

If your final data (especially if the monthly earnings between individual employees are too close together, there may be an overlay on the line graph that is not conducive to analysing the data)
In this case it is recommended that you switch on Logarithmic Scale.

The use of a logarithmic scale in line graphs can help to widen and narrow the gap between data, making changes in the data more visible, especially when the data range spans a wide range.

Here is my test data:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[kc_]

Thank you @Anonymous! Much appreciated!

[lbendlin]

That's a design red flag - you are showing the same data twice in the same visual. 

Use a different visual type (like a filled area chart) or use an aggregation (average instead of total).