Changing value on a stacked bar chart - power BI

[Anonymous]

Hello everyone,

Happy to have join the Microsoft Power BI community!

Here is my issue: I have the following charts (attached picture) and I'd like to have a percentage number (margin as % and not as whole number) within the margin bar (the middle one)

I know that in excel you can do the 'value as cell" and it will make appear whatever you want, but I do not know how to do it on power BI, does it even exist please?

Appreciate your help in advance,

Lucas

[Anonymous]

Hi @Anonymous ,

I don't quite understand your first request, you can share sample data or .pbix files. For the second requirement, you can use sort by column.Sort one column by another column in Power BI - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous 

Thanks for your reply

I can't have the possibility to attache a file in the forum .. can we continue this discussion by email maybe so that we can find a solution to my problem in a smoother way ?

[Anonymous]

Hi @Anonymous ,

There are two options to achieve this:

1.Using 100% Stacked column chart

2.Using Stacked column chart,finding data labels and turn on Custom label:

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for your help! In my case I would like to keep the 3 distinct columns (Revenues, Margin, Costs)

Do you think of another solution to customize this data label in particular?

Another question please, it is impossible for me to sort the figures from revenues, margin, and costs in the descending order (meaning: for revenues column, the biggest figure on the bottom and then going up the smaller one ; same for costs as well)

Do not hesitate if you have any idea on how to implement this, it would be so helpful!

Kind regards,

LM

[amitchandak]

@Anonymous , You can do that with new label customization, released in Dec-2023

New Power BI Data Label Customizations (December 2023) - https://youtu.be/qe3eW4OkAN8

Add % of subtotal measure in details of label

[Anonymous]

Hi, Thanks for the swift reply I tried what you said, while watching the YT video but cannot make it ...