Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
kc_
Helper I
Helper I

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.

kc__0-1730374646480.png

 

 

Many thanks

1 ACCEPTED SOLUTION
v-jtian-msft
Community Support
Community Support

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

vjtianmsft_0-1730691990416.png

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:

vjtianmsft_1-1730692115957.png


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.

View solution in original post

3 REPLIES 3
v-jtian-msft
Community Support
Community Support

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

vjtianmsft_0-1730691990416.png

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:

vjtianmsft_1-1730692115957.png


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.

Thank you @v-jtian-msft! Much appreciated!

lbendlin
Super User
Super User

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

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.