Particular product revenue as % of total revenue

[cheryl0316]

Below is an example of dataset.

Date	Product	Country	Revenue
01/01/2022	A	Mexico	20
04/01/2022	C	US	10
07/01/2022	B	Mexico	10
07/01/2022	B	US	10
07/01/2022	B	US	10
10/01/2022	A	US	10
10/01/2022	A	US	10
10/01/2022	A	Japan	10
01/01/2023	A	Thailand	10
04/01/2023	A	Japan	10
07/01/2023	C	Vietnam	10

There are slicers for Year and Quarter

I have created pages for each product.

 

e>ach page only shows visualization specific to its corresponding product type. For examples, I select "Filters on this page" for Product A on Product A page

I want to create a bar chart to show particular product revenue as % of total revenue.

If I select 2022 Q3 and Q4,

Total revenue = $60 (Mexico - $10, US - $40, Japan - $10)

Total Product A = $30 (US - $20, Japan - $10)

US: 50% (20/40)

Japan: 100% (10/10)

Any advice would be appreciated! Thank you!

[Ashish_Mathur]

Hi,

What do you mean by "I want to create pages for each product"?

[cheryl0316]

Hi Ashish,

There are 3 Product Types - A, B C. I have created dedicated pages for each product, and each page only shows visualization specific to its corresponding product type. 

I want to create a bar chart to show particular product revenue as % of total revenue

[Ashish_Mathur]

Hi,

The total revenue of product A in Q2+Q3 is 40.  Why are you treating the denominator as 50?  Also, not only do you want the % calculations, you also want the count of each % bucket.  Is my understanding correct?

[cheryl0316]

Hi

I want the percentage of Product A revenue for each country relative to the total revenue (i.e., the sum of revenue from Product A, B, and C) for 2022 Q2 and Q3. Hence, the denominator for this calculation is 50.

Yes I want the % calculation and the count of each % bucket. There will be two buckets - 0-50% and 51-100%. Thanks.

[Ashish_Mathur]

I just do not get it.  The revenue of Q2+Q3 of 2022 is 30.

[cheryl0316]

So sorry I made some mistakes. I have updated the data and post. Thank you so much

[Ashish_Mathur]

Hi,

PBI file attached.

Hope this helps.

[cheryl0316]

Hi

The formula is exactly what I am looking for. Thank you so much!

When I create the bar chart, PowerBI doesn't allow me to put measure - Revenue share into x-axis. Do you have any idea?

[Ashish_Mathur · Accepted solution]

You are welcome.  PBI file attached.

Hope this helps.