Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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.
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.
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.
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).
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |