Clustered column chart with multiple data labels

[nkamani]

Hello, 

I have a clustered column chart where the y-axis/bar height is based on a $ value. I want to add a data label that shows the count of rows that feeds into each column. The orange and blue columns are different measures. I've tried a couple measures in the Data Labels Value field, but I'm either getting the total of all rows for both columns in each quarter, or I can only get the count for one column for each quarter, but it displays that number for both columns. 

for the selected quarter, the orange column's label should be 9, and the blue columns label should be 4. 

Does anyone know how to resolve this?

[nkamani · Accepted solution]

@MFelix @Greg_Deckler 

I appreciate the quick response, but I actually figured this out. 

I just needed to select the individual series and then drag each "count" measure into the Data Labels Value field below. 

Now the chart is showing what I want. 

[MFelix]

Great job 

Dont forget to Mark your answer as the correct One só you can help others.

[Greg_Deckler]

@nkamani Perfect, there you go!

[MFelix]

Hi @nkamani ,

This depends on the measure you are calculating, can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[Greg_Deckler]

@nkamani What is your measure formula?