Forum Discussion
slicer
Need a date filter by using slicer which should filter start date and end date
when ever report gets loaded its should show values(default) form
start date should be :01-Feb-2023
end date should be: Today's day ( dynamically)
also when ever user want to change the start data and end date that option also need to enable in slicer. how we can do the same pls assist
This is a common question from Power BI novices.
Power Bi will "remember" the slicers settings when you publish a report and will always default to those settings.So if you publish a report with slicer =08Jan2024 today, then it will alway default to 8Jan2024 in future.
A common solution is to add new column in Power Query with if date = current month then "Current Month" else month. Then use this date in your slicer with "Current Month" as default.
Each time your Power BI data refeshes the date will move forward.See
https://www.youtube.com/watch?v=5dN4SqufENEhttps://www.youtube.com/watch?v=VaJ10ilXp6Y
https://youtu.be/JlVHsZUk1nc?si=m3Rtb4jLZt-NCF0-
Please click accept as solution and the thumbs up button
1 Reply
This is a common question from Power BI novices.
Power Bi will "remember" the slicers settings when you publish a report and will always default to those settings.So if you publish a report with slicer =08Jan2024 today, then it will alway default to 8Jan2024 in future.
A common solution is to add new column in Power Query with if date = current month then "Current Month" else month. Then use this date in your slicer with "Current Month" as default.
Each time your Power BI data refeshes the date will move forward.See
https://www.youtube.com/watch?v=5dN4SqufENEhttps://www.youtube.com/watch?v=VaJ10ilXp6Y
https://youtu.be/JlVHsZUk1nc?si=m3Rtb4jLZt-NCF0-
Please click accept as solution and the thumbs up button