Forum Discussion

Larry_Wang's avatar
Larry_Wang
Helper I
4 years ago
Solved

Customized Slicer

Hi everyone,   I want to create a customized or smart slicer that contains two parts of the date data. See table below for details of the data. If I create simple slicer using column "Date", it wil...
Need Help
  • dhruvinushah's avatar
    dhruvinushah
    4 years ago

    Hi Larry_Wang , Larry, 
    Thanks for the screenshot. 
    I would suggest to Power query to create the custom grouping based on your requirement. 
    Using the 'Add a Column' transformation in Power Query -> add a Conditional Column to your query. 


    Refer screenshot above to see the conditions for Old dates and new dates above. You can modify as and how you need. Any new dates that are added will follow suit using this condition. 


    If this helps, please remember to mark my answer as a solution to your question and give thumbs up!
    Thanks.

     

dhruvinushah's avatar
dhruvinushah
Responsive Resident
4 years ago

Hi Larry_Wang , Larry, 
Thanks for the screenshot. 
I would suggest to Power query to create the custom grouping based on your requirement. 
Using the 'Add a Column' transformation in Power Query -> add a Conditional Column to your query. 


Refer screenshot above to see the conditions for Old dates and new dates above. You can modify as and how you need. Any new dates that are added will follow suit using this condition. 


If this helps, please remember to mark my answer as a solution to your question and give thumbs up!
Thanks.

 

Larry_Wang's avatar
Larry_Wang
Helper I
4 years ago

Hi dhruvinushah ,

 

This conditional column works fine for me and I use a hierachy slicer to do the filter. See picture below for details.

 

 

But if I create two seperate slicers like the ones shown in picture below, and I select New in slicer Custom_Date and there is no change in the second slicer. I checked the interaction settings and no issue.

 

 

Thanks,

 

Larry