need to show previous week as default value in slicer.

[PBI_]

Hi Team,

Could someone please explain to me how to make last week's value the default in the Slicer visual? and send me some example PBIX files for reference.

[lbendlin · Accepted solution]

Here's the general approach - adjust as needed.

- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app

[PBI_]

Hi @lbendlin,
Can you please provide me with an example PBIX file using this method.

[lbendlin]