Multiple Value in Data Label format for Clustered column chart

[dbhadaur]

Hello All,

I have created a clustered column chart for my data and I have added percentage of two different category A & B (for example) in measure A1 and B1 resepectively

In the Visuals of Clustered column chart I have added A and B in Y axis and in X axis I have added the value which I want to show against Categories.

But when I am trying to add percentage which is stored in A1 and B1 Measures, I am able to add only one value in Data Labels.

I want to show percentage for both A and B Category separately so I want to add both A1 and B1 in "Add data" but aparantely I can add only one

Can someone help to resolve this issue?

[v-junyant-msft · Accepted solution]

Hi @dbhadaur ,

Data Label can only add one Value, by design. If you want to add separate Data Labels for A and B, then you can't use measure to calculate for A and B separately and then put them into the chart.
Here is my sample data:

I use this DAX to create a measure:

Measure = 
VAR _SUM =
CALCULATE(
    SUM('Table'[Value]),
    ALLEXCEPT('Table', 'Table'[Category])
)
RETURN
DIVIDE(MAX('Table'[Value]), _SUM)

Then create the clustered column chart, put the Category into the Legend:

After that, then I add the data label, and the final output is as below:

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