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

Cross filtering in Power BI report not working correctly

Hi, 

I have created a Power BI report from a single dataset, in the report there is a stacked bar chart which displays name (Y-axis )by sum of amount (X-axis), there is also a stacked column chart which has report date (X-axis) by sum of amount (Y-axis).

 

The charts do have cross highlighting however when I select the date "2024-09-21" which has a value of 41 i'd expect to see the 41 values highlighted on the name by sum of amount chart.

 

However the highlighed numbers I see are totally wrong, what is interesting is if I change the chart to a table I can see my "41" values as expected split by name with one person having 4 and the other person having 37.

 

For context there is no OLS or RLS on this dataset, there is also no duplicates in the table, there are no measures present.

 

Any advice on how to resolve this as i'm beginning to believe its a bug.

Status: Investigating

Hi @Jester_3 ,

 

Do you mean that the stacked bar chart fails to display the 41 values correctly on the table, but the table does?

 

Best regards,
Community Support Team_ Scott Chang

Comments
v-tianyich-msft
Community Support
Status changed to: Investigating

Hi @Jester_3 ,

 

Do you mean that the stacked bar chart fails to display the 41 values correctly on the table, but the table does?

 

Best regards,
Community Support Team_ Scott Chang

Jester_3
Regular Visitor

Hi,

Apologies for taking a while to reply to this.

 

What I mean is there is two charts, a stacked bar chart and a stacked column chart, the stacked column in question has a value of 41 and i'd expect it to cross highlight the bar chart to show me the values that belong to each user.

 

In my instance I'd expect to see a value of 4 highlighted for person A and a value of 37 highlighted for person B.

 

This however this does not highlight the correct values, but if I change the stacked bar chart to a table I can see the values i'd expect to see.

 

Hope this makes sense, also for the time being I just disabled cross filtering and highlighting to not confuse end users.

 

Best,

Jordan