Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
Hi @Shamatix,
Please, try this solution:
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!
Hi @Shamatix,
Please, try this solution:
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
138 | |
70 | |
64 | |
52 | |
50 |
User | Count |
---|---|
210 | |
92 | |
64 | |
59 | |
56 |