Forum Discussion
Modify Slicer Date
Hi Anonymous ,
Thanks for the reply from bhanu_gautam , please allow me to provide another insight:
You can filter the data in the slicer visual in the filters pane on the right to get only data from 1 January 2020 onwards.
More details about filters can be found in the documentation: Add a filter to a report in Power BI - Power BI | Microsoft Learn
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous & bhanu_gautam thank you. I used this option in the screen shot below to get what I am looking for
Hi Anonymous ,
Thanks for the reply from bhanu_gautam , please allow me to provide another insight:
You can filter the data in the slicer visual in the filters pane on the right to get only data from 1 January 2020 onwards.
More details about filters can be found in the documentation: Add a filter to a report in Power BI - Power BI | Microsoft Learn
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bhanu_gautam thank you so much for the response but would your solution also ensure that the date is auto changed every year?
E.g. In 2024, the start date on the slicer should be Jan 01 2020 and in 2025, the start date should be Jan 01 2026 and in 2027 the start date will be Jan 01 2028 etc. This will be dynamically done by the system.
Anonymous thank you so much for the response but would your solution also ensure that the date is auto changed every year?
E.g. In 2024, the start date on the slicer should be Jan 01 2020 and in 2025, the start date should be Jan 01 2026 and in 2027 the start date will be Jan 01 2028 etc. This will be dynamically done by the system.