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
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