how do i add a percentage value to column in line and stacked column chart

[nataoui]

Hi, 

I am trying to add a percentage to the column values for e.g. B = 70% while A is 30% during april. 

How can I achieve this? 

[v-piga-msft]

Hi @nataoui ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[MFelix]

Hi @nataoui ,

When you refer of addin column percentage is it an additional column or is it on the Tooltip?

Placing diffent types of values on the columns it will create a strange chart since unit will have to be the same so you cannot have one column in units and other in percentage using the same Y Axis.

If it's on the tooltip you can add a measure calculating the % and add it to the tooltip part of your visual.

Would be something like:

% Total A = SUM(Table[A]) / (SUM(Table[A]) + SUM(Table[B]))

% Total B = SUM(Table[B]) / (SUM(Table[A]) + SUM(Table[B]))

Can you share some more insights on what you need to calculate or show?

Regards,

MFelix

[nataoui]

Awesome this worked! One last question, how can I change it so it is a percentage w/o decimals?

[MFelix]

Hi @nataoui ,

You can do it selecting the measure and on the modeling tab select the % format and the number of decimal, the number of decimals can also be defined on the visual itself if you look for the decimal on the data labels part.

Regards,

MFelix

[nataoui]

Hi Felix, I mean that instead of the values of A and B, those be shown as a % on the bar itself - not tooltip. Right now, I can only do it as % of grand total but not each inidividual date. I want to compare A against B in % which both should total 100%. 

[MFelix · Accepted solution]

Hi,

If you use the two measure I placed on my previous post it should do the trick.

Please check and get back to me if possible with sample data.

Regards,
MFelix