Drillthrough & Slicers

[BrunaSeixas]

Hello, 

I would like to know if there is any way to drillthrough to another field in my hierarchy and the slicer that is in the same page only shows the parental value that I´ve selected. So just as example:

• I have a hierarchy with two fields:
  • Country
    • Operators

1-No country selected:

2- Once I select a country on the chart using drillthrough (e.g. Spain), nothing happens! Even if my "Drilling filters other visuals" is on

Isn´t there any possibility that my slicer is filtered and the only value that shows is Spain?? If not, whyyyyy?

KR, 

[Anonymous]

@BrunaSeixas

@v-yuta-msft    the regular slicer is not working.. I tried this with custom slicer "Chicletslicer"  and its working. Only filter option is working not the highlighting one.

In the regular slicer there is visual filter icon but still its not working even if its selected...

[Anonymous]

@BrunaSeixas  i guess  visuals does not filter slicers...slicers get filtered by other slicers only.

[Anonymous]

Hi @BrunaSeixas

Quick Qn : The country you used in slicer and the visual - Both are from same table?

There is a possibility that you selected both are from different table and the cross filter direction is not set properly. SO, please check your relationship and the cross filter direction. Suppose cross filter direction is from Table A to Table B, make sure country from Table A is used in the slicer

Thanks
Raj

[BrunaSeixas]

Hi, 

Yes it is coming from the same table. On the slicer I tried to use the country that comes from the the hierarchy and also the one that is not on it, both did not work. 

So it should be filtering the slicer?

KR, 

[v-yuta-msft]

Hi BrunaSeixas,

Couldn't reproduce your issue. You can use hierarchy slicer and check if it can meet your requirement. PLease refer to: https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=Overview. If still can't filter the visual, could you share your hierarchy structure?

Regards,

Jimmy Tao