Reply
Shamatix
Post Partisan
Post Partisan

Default date values in slicer

Hey fellow users of Power Bi,

 

I have a slicer with a from and to date  as seen on the below picture.

I want this slicer to ALWAYS start with the last years values, for example today its the 14-03-2018 so I want it to default to 14-03-2017 to 14-03-2018 HOWEVER I want the user to still be able to drag the slicer more to the "left" to expand it to years before 2017 as well.

I just want it to START with the latest year chosen by default, how is this possible?

1 ACCEPTED SOLUTION
McCow
Resolver III
Resolver III

Hi @Shamatix,

 

Please, try this solution:
2018-03-14 (2).png

 

 Here is the sample code

 

Left slicer is a switch between one year operations "1" (button slicer for control, from now-365 to now) and "All" dates.
"0" - is another dates (not last year) of need.

 

Best regs!

View solution in original post

1 REPLY 1
McCow
Resolver III
Resolver III

Hi @Shamatix,

 

Please, try this solution:
2018-03-14 (2).png

 

 Here is the sample code

 

Left slicer is a switch between one year operations "1" (button slicer for control, from now-365 to now) and "All" dates.
"0" - is another dates (not last year) of need.

 

Best regs!

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)