Forum Discussion
Month Filter-Preselected Current month
Hi Anonymous
Several ways to do this.
Most of what everone would suggest is to create a calculated column that checks whether a date is in the current month and return say "current month" otherwise the month name. That, thought, doesn't dynamically select the current month name but of course the word current month.
Another method leverages the Group by Columns property to "store a filter by using an alternate value, which represents the key of the entity" using Tabular editor. Power BI uses this key to store the filter, allowing the corresponding filter value in the visual to change dynamically. For instance, if May-24 is selected in the visual and currently has a key of 0, when June arrives, May will shift to a key of 1, and June will take the key of 0. Consequently, the slicer selection will automatically change to June. Please refer to this YouTube video - https://www.youtube.com/watch?v=MrEAZREQuXM
Please be aware that regardless of the method you use, if persistent filter is enabled, Power BI will load the previous slicer selection of the user the next time they open the report in the service.
Hi Anonymous ,
To pre-select the current month in your dimUmsatzDatum[Month Name] slicer when the report loads, you need a calculated column in dimUmsatzDatum that determines whether a row belongs to the current month. Since dimUmsatzDatum[Month Name] contains only the month name, you should ensure that both the month and year are checked to avoid ambiguity.
Create the following calculated column in dimUmsatzDatum:
IsCurrentMonth =
IF(
FORMAT(TODAY(), "MMMM") = 'dimUmsatzDatum'[Month Name] &&
YEAR(TODAY()) = YEAR('dimUmsatzDatum'[Date]),
1,
0
)
After creating this column, add dimUmsatzDatum[Month Name] to the slicer. In the Filters on this Visual pane, apply a filter where IsCurrentMonth = 1. This ensures that the slicer defaults to the current month when the report is opened, while still allowing users to change the selection if needed.
Alternatively, if your dataset contains a full date column, you can achieve the same effect using relative date filtering. Instead of Month Name, use dimUmsatzDatum[Date] in the slicer and apply a relative date filter set to "This Month." This approach ensures the report opens with the current month selected while maintaining user flexibility.
This method provides an automatic pre-selection of the current month without requiring bookmarks or manual adjustments.
Best regards,