Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
excellent
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
Hello @Nomadexchris, any updates on the issue? I have the same use case, did you find any workaround?
Kind regards.
@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
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
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.