Forum Discussion

sunilpatel's avatar
sunilpatel
Regular Visitor
5 years ago

Help in Slicers

Hi, 

I have two slicers in my report, 1st contains date, month and week. if i select month, second slicer should show dropdown values for only month. if i select week, second slicer should show dropdown values for only week 

beow is the screen shot. please help 

 

 

 

Need Help
Tips and Tricks

1 Reply

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    I'm afraid it is not possible to dynamically change the data type of values shown in slicer. In this workaround, it looks like fields displayed in slicer are dynamic, actually, all displayed selections in slicer are from a single column. But one column can have only one data type. Based on my test, there is no workaround to achieve such a requirement.