Showing % of cluster & not the entire data set in clustered column chart

[harshadrokade]

HI,

I have below shown clustered chart created where I want to show % instead of numbers. If I use 'Show value as %' option available in Value field (right click), it calculates the % of the entire data set. But I want to calculate the % between each light blue & dark blue seperately. Example, I want to see in first light blue & dark blue % as 40% & 60% & not 2 &3.

How can I do this. Pls help

Using 'Show value as %' option available in Value field (right click), gives result as below which I don't want. It is considering entire dataset as 100% then deviding all the bars in 100%. I want to consider each light blue & dark blue set of bars seperately as 100%

[jppv20 · Accepted solution]

Hi @harshadrokade ,

Create this measure:

Percentage =

var TotalClass = CALCULATE(SUM('Table'[Count]),ALLEXCEPT('Table','Table'[Class]))

var Total = SUM('Table'[Count])

Return

DIVIDE(Total,TotalClass,BLANK())

Put it in table like this:

If I answered your question, please mark it as a solution to help other members find it more quickly.

[harshadrokade]

HI @jppv20 , Would it be possible for you to help me with above query?

[jppv20]

Hi @harshadrokade ,

Can you give some example data from your table? Doesn't need to be with real numbers.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[harshadrokade]

@Ashish_Mathur Sorry Sir, My organisation doesn't allow uplaoding the files anywhere & so I can;t share the PBIx file or link for the same. Will you be able to help me without PBIx file sir, pls

[Ashish_Mathur]

Hi,

Please prepeare a dummy dataset and show the problem clearly on that dataset.

[harshadrokade]

HI @jppv20 @Ashish_Mathur 

Pls refer below data. I have drawn the clustered column chart also as shown below which is giving wrong %. I want % to be shown on cluster as shown in the table.

Table name - Class

Columns as below-

'Class	'Status	'Count	'% to be shown on Clustered column chart
Class A	Pass	20	53%
Class A	Fail	18	47%
Class B	Pass	27	79%
Class B	Fail	7	21%
Class C	Pass	27	57%
Class C	Fail	20	43%
Class D	Pass	11	31%
Class D	Fail	25	69%
Class E	Pass	13	35%
Class E	Fail	24	65%
Class F	Pass	26	51%
Class F	Fail	25	49%

Power bi visual with count-

Power bi visual with % (% appearing here is wrong. I want the % as shown in table)-

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[harshadrokade]

This is awesome. Thanks @Ashish_Mathur  Sir

[Ashish_Mathur]

You are welcome.

[jppv20 · Accepted solution]

Hi @harshadrokade ,

Create this measure:

Percentage =

var TotalClass = CALCULATE(SUM('Table'[Count]),ALLEXCEPT('Table','Table'[Class]))

var Total = SUM('Table'[Count])

Return

DIVIDE(Total,TotalClass,BLANK())

Put it in table like this:

If I answered your question, please mark it as a solution to help other members find it more quickly.