I'm using the Hierarchy Slicer,
when i'm trying to filter multiple selection like the example below:
Type | CCY
I'm getting an error:
"we can't display this visual because a measure is used in cross highlighting"
If i filter like this:
Type | CCY
What does this error means and how can i resolve this?
I tested the Hierarchy Slicer in my desktop file, it worked fine, I could not reproduce your problem. It looks lke the error message you encountered was related to the measure displayed in visual.
For further analysis, please share sample data (including table structure, relationships and sample data records) and the formula of this measure and how you created the report so that I can try to replicate your scenario.
I attached a sample of what i'm trying to do.
there are 2 tables there:
1. the one that cause error - the "pl" field is using sum
2. the one that works fine - the "pl" field is not using aggregate function
It looks like an issue with custom visual "Hierarchy Slicer". I noticed that some records are shown as (blank) in slicer, please delete dataset and load data agian to see whether it works. Also, please contact the author of this custom visual via adding comments at this page.