Highlighting gives incorrect results for one category

[ACT]

So, this is a chart of client ID's that are distinct in that month (using bins on datetime). When I click the different employment status values in the table below, I get the very strange behavior of the "Unemployed" value displaying probably 5 times the number of clients that it should--4+ times higher than a category that is 30% bigger--and there seems to be no reason for this, as all the other categories work fine, descending just as expected. You can see the top category for comparison...the category below Unemployed works fine, as do all the rest.

This should be pretty straightforward...I've just started this project, so there are very few visualizations, none of which are applying anything. The only thing I can add is that I've established a many to one relationship between a table which contains billing history to get client interactions with clinics, to a demographics table which has only one record per client; I applied a cross filter direction "Both," and "Make this relationship active" is checked. But why would it only affect one category? What's going on here?

Butwhy?

[v-yulgu-msft]

Hi @ACT,

In the table visual, the "count of employee value" show the total count per category in all years and all months. While the chart visual show the count value for each category per year per month when you click one category in table visual. Besides, please open the "Data label" option, to check whether the dispalyed value on chart is correct when it is filtered for a specific category.

Regards,

Yuliana Gu

[ACT · Accepted solution]

Thank you Yuliana. I figured it out. The problem was (of course my fault) that while the chart was displaying the right total numbers based on client ID, the chart highlighting was using a count of employment_value, which I thought was limited by the client IDs from the billing table (which are a subset of all the clients in our database), but wasn't. And the table was also not limited by the client ID's. I think I was assuming that the table relationship acted like a left join.

I kind of feel like I should delete these noob questions sometimes. But hopefully they're helpful for somebody.