Forum Discussion

vishal_singh's avatar
vishal_singh
Frequent Visitor
9 years ago

slicer hierarchy

I have been struggling to create a depenency between slicer, i.e. the the second slicer options displays based on first slicer.   For example: I have data for number of mobile Phones registered for...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi vishal_singh,

 

According to your description, you should be able to use the Edit Interactions feature to change the interactions between the Slicers.:smileyhappy:

 

First select the Slicer for Month on the report, then go to Format tab and select Edit Interactions.

 

 

Change the interactions to None for the Slicer of Year.

 

 

Then the two Slicers should work as your expected.

 

 

Regards

vishal_singh's avatar
vishal_singh
Frequent Visitor
9 years ago

Hi,

 

Thanks, atleast it works but I am facing a new problem here.

 

In my 2016 data, I have months only from July to December and for 2017 only Jan.

 

Now when I select 2016 year and December month, I get data as expected. When changing the year to 2017, which should autmoticaly show only Jan in Month slicer, shows Dec and Jan. However, for Dec month the graph is empty and I click Jan to get the data in graph. In you screenshots when you select Year 2017, you get only Jan Month in the Slicer list. It doesnot happens in my case.

 Sorry I cannot put my jpg file here. 

 

 

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi vishal_singh,

     

    I can reproduce the same result as yours on my side too. And this is the default behavior which cannot be changed currently. For more details about this, you can refer to a similar thread here.:smileyhappy:

     

    Regards