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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ACT
Frequent Visitor

Highlighting gives incorrect results for one category

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?Butwhy?

1 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.

View solution in original post

2 REPLIES 2
v-yulgu-msft
Microsoft Employee
Microsoft Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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