Add label or tooltip showing % of total on barchart

[Train_herb_613]

Hi all,

I have some data and I'd like to make a chart in PowerBI that shows the sales for a particular country. I would also like it to show what % those sales are for global sales of each product. E.g. I start with this data:

Product	Country	Sales
Oranges	UK	650,000
Oranges	India	100,000
Oranges	South Korea	150,000
Apples	USA	25,000
Apples	China	450,000
Apples	UK	250,000
Apples	India	100,000
Apples	South Korea	75,000
Bananas	China	150,000
Bananas	UK	25,000
Bananas	France	450,000
Bananas	India	150,000
Bananas	USA	100,000

Here's the graph in Excel. The important bit is in yellow

I've tried searching and creating a measure but I can't get my head around what I need to do. I'm completely new to PowerBI and I can create this, but I'm not sure where to start with the % element. Thanks for any help!

[Ashish_Mathur]

Hi,

Would you be OK if the % appears (as a tooltip) when you hover the mouse over the bar?

[Train_herb_613]

Yes, that would be OK too.

Thanks!

[Ashish_Mathur · Accepted solution]

Hi,

Please find attached the PBI file.

[Jihwan_Kim]

Hi,

Please check the below picture and the attached pbix file.

Sales label measure: =
VAR _totalincountry =
    CALCULATE ( [Sales measure:], ALL ( Country[Country] ) )
RETURN
    DIVIDE ( [Sales measure:], _totalincountry )

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

[Train_herb_613]

Here you go. You can see the expected outcome in my first post, but here it is again:

https://drive.google.com/file/d/1AI_Fzh1-BWchruAt7bTKf8EKMZChW8tJ/view?usp=sharing