Forum Discussion
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 will include all date data. See below picture.
What I want is in the slicer I can separate it into two parts, one is before 12/20/2021 and the other one is after (include) 12/20/2021.
| Product | Rating | Date |
| ID1 | 1 ++ | 5/12/2018 |
| ID2 | 2 + | 6/24/2018 |
| ID3 | 2 + | 11/18/2018 |
| ID4 | 3 o | 3/31/2019 |
| ID5 | 4 - | 4/11/2019 |
| ID6 | 5 -- | 7/17/2019 |
| ID7 | 4 - | 2/9/2020 |
| ID3 | 4 - | 3/10/2020 |
| ID4 | 1 ++ | 10/21/2020 |
| ID5 | 3 o | 11/9/2020 |
| ID6 | 5 -- | 11/25/2021 |
| ID1 | 5 ++ | 12/20/2021 |
| ID2 | 4 + | 1/4/2022 |
| ID3 | 1 -- | 2/19/2022 |
| ID4 | 2 - | 5/30/2022 |
| ID7 | 4 + | 7/13/2022 |
So what I want to see the slicer is like below:
Thanks,
Larry
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.
4 Replies
Hi Larry Larry_Wang ,
One idea that popped up in my head for your requirement was for you to create a button functionality for you or your end user to filter the report page before/after your date: 12/20/2021.
You can do so by creating a power BI group on your date field. Group dates into two categories:
1. old dates (from beginning till before 12/20/2021)
2. new dates ( from 12/20/2021 {including} and forward to your last date}
You can then bring this group onto a horizontal slicer {which will appear as buttons} and add the newly created group field into it.
The user can simply select Old Dates for those dates or the New Dates.Let me know if you need any help further along this idea.
hope this helps. ThanksHi dhruvinushah ,
Thank you for the suggetion on this issue. I did a test but I can only create group by list and if I add some new data entries in the source file, I can see some ungrouped values. See below picture for details. It is better to create a group or new column that converts all date earlier than 12/20/2021 with value "old" and the rest of the date change to "new".
Thanks,
Larry
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.
