Discrepancy in Legend Counts within Power BI Stacked Bar Chart

[Riccardo_O]

Hello,

I'm experiencing an issue with a stacked bar chart in Power BI and hope to find some guidance here. The chart is designed to display data across three dimensions:

• Y-axis: Represents company names.
• X-axis: Shows the distinct count of email addresses associated with each company.
• Legend: Differentiates whether an email address has been contacted or not, marked as "Y" for yes and "N" for no.

Data Structure Overview:

• Company Name: Indicates the name of the company.
• Count of Email: Represents the distinct count of email addresses for each company.
• Legend (Contacted): Shows whether each specific email address was contacted, with "Y" for yes and "N" for no.

Issue Encountered:

Based on the data from the CSV file, for example, Company_1 should have a count of 85 emails, with 44 marked as "Y" (contacted) and 41 marked as "N" (not contacted). However, in Power BI, while the company name and count of emails display correctly, the legend counts are incorrect. Instead of showing 44 "Y" and 41 "N", it displays 85 "Y" and 81 "N".

I've attached screenshots for a clearer understanding of the issue. It seems there's a discrepancy in how the "contacted" status is being counted or displayed in the legend.

Could anyone provide insights or guidance on how to correct these legend counts to accurately reflect the data? 

Thank you in advance for your assistance.

[amitchandak]

@Riccardo_O , Is count or distinctcount. If it distinctcount and both legends have values over some time. So need to check the data

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Riccardo_O · Accepted solution]

@amitchandak , Thank you very much for the answer. I found where the issaue was: There were some email addresses that had both conditions (Y and N). I used a different approach and now it is working.