Show data label as percentage of total for stacked bar chart instead of absolute value

[Nomadexchris]

Hi guys,

I was wondering if there is a workaround for Power BI stacked bar chart to show percentage of total (example below) instead of absolute value. By default only 100% stacked column chart could show data label in percentages but I would like to replicate sometime similar to the chart below instead. Thanks!

[voldelord]

excellent

[tbennett93]

A half-solution I have found to allow you to simultaneously display absolute values and percentages is to use a Line + Stacked Column chart and put your percentage measure on the secondary y-axis and change your line width to 0px. It does achieve a different result to what you're after as the percentage won't position themselves inside the stacked bars like you're requesting. They would either position according to the 0->100% secondary y-axis or you could get a single measure to display at the bottom of each column, like this:

This shows the absolute values as well as the percentage of purple vs pink

[Anonymous]

Hello @Nomadexchris, any updates on the issue? I have the same use case, did you find any workaround?

Kind regards.

[amitchandak]

@Nomadexchris , You have to create a % measure and then show that as value and a total measure that you have to show as line and make line color same as background or #FFFFFF00

Meausre1 = calculate([measure], removefilters(Table[series]))

or

Meausre1 = calculate([measure], filters(allselected(Table[series]), Table[series] = max(Table[series])))

% total = divide([Measure], [Measure1])

Use Measure 1 and % total

[Nomadexchris]

Dear @amitchandak, thanks for your response. However, I think the result will be a 100% stacked chart with a total amount. However, this would not allow me to show the overall trend using the bar chart

[Gladiator909]

Hi @Nomadexchris have you had any luck in recreating the chart from your example?

I have the same use case and can't figure a way around it and all the solutions from Microsoft experts all point to 100% stacked charts.