Represent value in Milions in a Bar Chart + Represent % from a different value (not from the total)

[Anonymous]

Hello everyone 🙂

I have this dataset (values in Milions):

DIM	Fix Cost	Liberado	Replanificado	Imputado	CAPA %
A	25,0	32,0	20,0	7,1	28%
B	22,0	55,0	72,0	13,6	62%
C	45,0	62,0	92,0	19,0	42%
D	44,0	87,0	41,0	16,8	38%
E	56,0	55,0	22,0	8,8	16%
F	41,0	11,0	25,0	10,8	26%
G	68,0	22,0	7,0	4,9	7%
H	88,0	88,0	2,0	2,0	2%
I	55,0	44,0	7,0	3,1	6%
J	11,0	77,0	5,0	1,5	14%
K	33,0	87,0	5,0	1,4	4%
M	11,0	98,0	2,0	1,7	15%

And so, my client needs to see in a chart the values (columns) in Millions and in the same time the % of that value, but not from the total of the other values (columns added) in Millions; he wants to see the % of the value from another different value that is in another (single) column. For instance, something like this:

I was trying several options with other kinds of visuals (like the lineStackedColumnComboChart) but it doesn't work:

Also, he told me that the option to put 2 charts separatelly is not usefull for him (one with values and another one with % from the Fix Cost column).

Could anyone help me to figure out if there's a way to do it, please? I'll appreciate it a lot 🙂

Thanks and kind regards,

Ana M.

[Anonymous]

Hello,

Thanks for your answer, but I'm afraid to say that this is not what I need.

This is my dataset.

DIM	FIX	LIB	REP	IMP
A	25	12	16	7
B	87	18	23	13
C	45	9	22	19
D	44	7	15	16
E	56	10	19	8
F	62	23	21	4

What I need to represent is a chart where it shows several columns in Millions (LIB, REP, IMP) and, at the same bars or chart, the % of the columns (LIB, REP, IMP) from another different column (FIX). For instance for A:

% LIB (A) = LIB/FIX * 100 = 48%

% REP (A) = REP/FIX * 100 = 64%

% IMP (A) = IMP/FIX * 100 = 28%

This means that the data label of each bar shows 2 values: one in millions and another one in %. For example, something like this:

Please if you kindly bring a solution it helped me more if you use my same dataset, so I can understand the solution properly.

Thank you so much for your help 🙂

Kind regards,

Ana M.

[v-rongtiep-msft]

Hi @Anonymous ,

Now Power BI does not support show a value and percentage at the same time in th bar chart. But you can put them in the table as a text type like I have provided.

Or you can vote here.

Provide Value and Percentage show option in Bar Chart 

Best Regards

Community Support Team _ Polly

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

[v-rongtiep-msft]

Hi @Anonymous ,

Based on my test, we will need to create a calculated column in the original table and make the values in the calculated column display as 100 000 ( 88.15%) format.

Create two columns.

SumBytype = CALCULATE(SUM([Column3]), ALLEXCEPT(Table3, Table3[Type]))

Lastcolumn = Table3[Column3] & "("  & ((Divide(Table3[Column3],Table3[SumBytype]))*100 & "%") &  ")" 

Please note that after creating the calculated column, we can only drag it into Table visual in order to show the values properly(as shown in the following screenshot). As the calculated column is text type, in other visuals, it will be counted.

Or you can create tooltips.

Customize tooltips in Power BI 

• 

Or you can create an idea here.

If I have misunderstood your meaning, please provide more details.

Best Regards

Community Support Team _ Polly

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