To ensure that the latest week is selected by default in your Power BI report when a user opens it, and to do so without using any DAX code, follow these simple steps:
Sort the Week Column in Ascending Order:
- Make sure your Week of Year column is sorted in ascending order.
- Click on the Week of Year column in the Fields pane.
- In the Column Tools tab, ensure that the column is sorted in ascending order by clicking the Sort ascending button if necessary.
Add the Slicer to the Report: - In the Report view, go to the Visualizations pane and select the slicer visual.
Drag the Week of Year column from the Fields pane to the slicer.
Enable Single Select: - Click on the slicer visual to select it.
- In the Visualizations pane, go to the Format pane (paint roller icon).
- Expand the Selection controls section.
- Toggle the Single select option to On.
By doing this, the slicer will automatically select the latest week (the highest value) when the report is opened, as it will be sorted in ascending order. The single-select setting will ensure that only one week is selected at a time. This approach is simple and avoids the need for any additional DAX calculations or complex configurations.
