cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eranmn Regular Visitor
Regular Visitor

Hierarchy Slicer Issue

Hi,

 

I'm using the Hierarchy Slicer, 

when i'm trying to filter multiple selection like the example below:

 

Type   |    CCY

FI

              BRL

              USD

              ILS

FX

(all)

 

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

FI

             

FX

 

it's ok.

 

What does this error means and how can i resolve this?

 

 

 

Regards,

Eran

 

3 REPLIES 3
Community Support Team
Community Support Team

Re: Hierarchy Slicer Issue

Hi @eranmn,

 

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.

 

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.
Highlighted
eranmn Regular Visitor
Regular Visitor

Re: Hierarchy Slicer Issue

Hi @v-yulgu-msft

 

I attached a sample of what i'm trying to do.

 

https://www.dropbox.com/s/r6hleybhjgm4egk/HierarchySlicerEx.pbix?dl=0

 

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

 

Regards,

Eran

Community Support Team
Community Support Team

Re: Hierarchy Slicer Issue

Hi @eranmn,

 

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.

 

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.