Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
dbhadaur
Frequent Visitor

Multiple Value in Data Label format for Clustered column chart

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.

dbhadaur_0-1711049839845.pngdbhadaur_1-1711049883675.png

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?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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:

vjunyantmsft_0-1711071467668.png

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:

vjunyantmsft_1-1711071516273.png

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

vjunyantmsft_2-1711071577795.png

 

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.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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:

vjunyantmsft_0-1711071467668.png

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:

vjunyantmsft_1-1711071516273.png

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

vjunyantmsft_2-1711071577795.png

 

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors