- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Graph Showing both Revenue by against and Total Company Revenue
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-02-2025 03:59 AM | |||
09-08-2024 10:31 AM | |||
02-04-2025 08:45 AM | |||
11-14-2024 01:32 AM | |||
11-07-2024 02:41 PM |
User | Count |
---|---|
136 | |
107 | |
88 | |
58 | |
46 |