Forum Discussion

difolt's avatar
difolt
Frequent Visitor
7 years ago

Cross highlight issue

Hi,   why I can not do something like this? I selected Customer A and specific date from Customer B. And all I need is count. 6+2 = 8. Please find PBIX file. https://drive.google.com/file/d/1Px02...
Show and Tell
johncpratt's avatar
johncpratt
Icon for Advocate III rankAdvocate III
2 years ago

This issue still exists as of today in the May 2023 GA release of Power BI Report Server.  I can also confirm that it affects both stacked column and ribbon charts displaying a total revenue number (measure) that is filtered by both the legend category in the visual (i.e. the stack categories) and the fiscal year on the X axis.  These are two separate dimensions in the data model and do NOT represent two different levels of the same hierarchy. 

 

If I select a legend value in one chart and a fiscal year value in another chart on the same page, it works fine, even though the fiscal year in both charts comes from the same dimension.

 

I can also add that I do not have this problem with a different stacked column/ribbon chart that uses a value from the fact table as the stacked category and the same fiscal year dimension as the chart with the problem.

 

I am reasonably certain that this was not an issue at some point in the past, as I have reports dating back to Fall 2017 that I have never seen this behavior in but are now experiencing the error.