Forum Discussion

MillarJayakumar's avatar
MillarJayakumar
Frequent Visitor
2 years ago
Solved

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 b...
PBI Desktop
  • speedramps's avatar
    speedramps
    2 years ago

    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=5dN4SqufENE

    https://www.youtube.com/watch?v=VaJ10ilXp6Y

    https://youtu.be/JlVHsZUk1nc?si=m3Rtb4jLZt-NCF0-

     

    Please click accept as solution and the thumbs up button

speedramps's avatar
speedramps
Icon for Super User rankSuper User
2 years ago

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=5dN4SqufENE

https://www.youtube.com/watch?v=VaJ10ilXp6Y

https://youtu.be/JlVHsZUk1nc?si=m3Rtb4jLZt-NCF0-

 

Please click accept as solution and the thumbs up button