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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Employee
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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.