Calculate Percentages on Bar Chart

[lharper]

Hello, 

I have some demographic data and I am creating bar charts. The dataset is one row per respondant. I'd like to display both the number of and percentage of respondants for each race category in the bar chart, like in the example below (generated in Tableau). I have seen solutions for creating stacked column and line charts as a workaround, but the percentages do not display well on the smallest categories. 

Any solutions for easily displaying displaying percentages? It does not necessarily need to be in the bar chart format, though that is preferable. 

[ray_aramburo · Accepted solution]

Bar charts and column charts by default can't include percentages in the labels but a workaround that may work is the next one.

Create a measure like this:

Label= CONCATENATE(CONVERT([MeasureThatGetsTotals], STRING), " (" & CONVERT([MeasureThatGets%Total],STRING) & ")")

Then, turn on the Data Labels, in Values turn on Custom label and drag & drop the created Label measure there.