Cross highlighting switches to filtering

[yelsherif]

In some calculations, bar charts can be created from positive and negative values, summing up to the value represented in the chart.

But when the bar chart is cross highlighted by other visual, there are possibilities that the affected value is out of the original bar limits, e.g. effective value is -20 while the original bar is 100, or effective value is 130 while the original bar is 100.

This case causes the chart to be "filtered" instead of cross highlighted.

Although the outcome chart is absolutely correct in terms of values, but is causes user confusion as they do not expect to see this kind of chart.

Also cross highlighting through charts showing percentages (i.e. percent of the grand total) produces a chart showing one value at 100%.

I see there is a need for a fix, or a kind of control for the way cross highlighting works

[v-yuezhe-msft]

@yelsherif ,

Could you please share sample data of your table here and post screenshots about your scenario?

In addition, we would need to know if you create any measures/columns and then drag measures/columns to bar chart.

Regards,
Lydia

[j_v]

I have the same problem. I have a stacked bar chart with sales by year (each bar has different sales categories) and a treemap with customers. If a customer is selected in the treemap, this customers share of the sales is higlighted in the bar chart. In some cases it can happen that a customer has a negative value for the sales, altough the total amount is positive. If this happens the bar chart is filtered instead of highlighted (since you can't higlight a negative value in a positive total). The filtering is indeed confusing for the end user. Keeping the highlighting would off course mean that the highlighted part goes outside of the total, so maybe change the thickness of the highlighted bar in this case? This way you can still see how the selected part compares to the total.