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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
cheryl0316
Frequent Visitor

Particular product revenue as % of total revenue

Below is an example of dataset.

 

DateProductCountryRevenue
01/01/2022AMexico20
04/01/2022CUS10
07/01/2022BMexico10
07/01/2022BUS10
07/01/2022BUS10
10/01/2022AUS10
10/01/2022AUS10
10/01/2022AJapan10
01/01/2023AThailand10
04/01/2023AJapan10
07/01/2023CVietnam10

 

 

There are slicers for Year and Quarter

cheryl0316_6-1707340070474.png

I have created pages for each product.

cheryl0316_0-1707350013234.png

 

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

 

 

cheryl0316_7-1707340095265.png

 

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)

 

cheryl0316_8-1707340123657.png

 

 

Any advice would be appreciated! Thank you!

 

 

 

 

1 ACCEPTED SOLUTION

You are welcome.  PBI file attached.

Hope this helps.

Ashish_Mathur_0-1707453186208.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

9 REPLIES 9
Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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. 

cheryl0316_0-1707350013234.png

 

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

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?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.

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

Ashish_Mathur_0-1707399403075.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

Hi,

PBI file attached.

Hope this helps.

Ashish_Mathur_0-1707441321127.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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?

You are welcome.  PBI file attached.

Hope this helps.

Ashish_Mathur_0-1707453186208.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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