cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jitendrabi07 Regular Visitor
Regular Visitor

customize slicer drop down menu option

Hi,

I am using a dropdown slicer on a Year field. This year field has few values (2017,2018,2019)

In the slicer dropdown, It shows:

Select all

2017

2018

2019 

Now, i need to change these dropdown values like this:

Select all

Previous 2 Years

Current Year (2017,2018,2019)

 

Please help how to achieve this.

 

Thanks,,

@Nathaniel_C 

@AnujMishra_09 

2 REPLIES 2
Community Support Team
Community Support Team

Re: customize slicer drop down menu option

Hi jitendrabi07, 

You could create a new table for the custom slicer. I want to check the result of slicer with you. When you choose previous 2 yaer, did you want to get sum of previous years(2017+2018)? Or you want to see 2017 and 2018 in visual? And the current year, did you want to see 2019 only or want to see 2017,2018,2019 in visual?

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jitendrabi07 Regular Visitor
Regular Visitor

Re: customize slicer drop down menu option

Hi,

For previous 2 Years means, the data should be visible for 2017 and 2018. 

The current year: the data should be visible for 2017,2018,2019.

Please share the DAX code how to get this. 

 

Thanks,

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)