Combine Bar visually and calculate Percentage of Total

[YanmarJS]

Hi,

How do I combine in visuals and show the Percentage on the following.

I have a column "Sales" which is the grand total number next to that I have a column "Marginal Profit" which is a total profit within the Sales numbers.

Visually I want the Marginal profit bar to be inside the Sales bar, then also showing the Percentage value (along with the EURO value) of the Sales.

Thanks in advanced.

P.S.

PowerBi Beginner here :3

[v-chuncz-msft · Accepted solution]

@YanmarJS,

You may try to use Stacked column chart, add [Marginal Profit] and the following measure to Value, and take advantage of Tooltips.

Measure =
SUM ( Table1[Sales] ) - SUM ( Table1[Marginal Profit] )

[YanmarJS]

Thanks!  that worked