Display number and percentage at same time in bar chart

[Anonymous]

Hi,

I have a barchart and I like the numbers to be shown as 57% (120), where 57% is some calculation (not stacked!) and 120 is the number of observations.

Is this possible?

[Amratya]

you can do it in the Pie chart from the label style

choose Data value, Percentage of total

couldn't find it in the bar chart

[Anonymous]

It would be great if that feature is added to bar chart too!

[Anonymous]

Hi, 

I have been trying do the same thing -  has there been an update on this?

"Looking to create a visual report in Power BI to compare the number of times people have picked a category. Due to the number of categories to compare(7) I have tried using the Bar Chart. The only issue is I want to display the data with the count of picks and the percentages of that pick as part as a total.

Is there a way I could do this in Bar chart?"

I could do this in Pie chart but it seems like the bar chart could only allow you to do one or the other

[bizbi · Accepted solution]

Not aware of a direct method but a possible workaround may be to use a Measure as a tooltip:

Measure=[M1] & " (" & [M2] & ")"

where [M1]=percentage measure and [M2]=count measure

Hope this helps!

[nitinrungta]

Why are we marking "Closest Answers to the solution but not the solution to the question" as a solution. What purpose does it solve?

The correct solution should be of @Greg_Deckler "As a tooltip yes but I don't think in the actual chart itself."

Secondly, coming to the solution of the "tooltip measure" by concatenating, that's not even required. Just drag and drop the "values" and "percent of total". It will show as a tooltip as such.

[Greg_Deckler]

As a tooltip yes but I don't think in the actual chart itself.