Current year by default as no year selected

In Power BI using DAX, you can create a measure that checks if the slicer value is blank and, if so, applies the maximum year as the filter. Here’s how you can do it:

1. Create a Year Slicer: Ensure you have a slicer in your Power BI report that allows users to select a year.

2. Create a Measure: Write a DAX measure to apply the maximum year when the slicer is blank.

Here is an example of how you can do this:

SelectedYear =
IF(
    ISBLANK(SELECTEDVALUE('Calendar'[Year])),
    MAX('Calendar'[Year]),
    SELECTEDVALUE('Calendar'[Year])
)

• 'Calendar'[Year] is the column from your date table (replace Calendar with your actual date table name).
• SELECTEDVALUE('Calendar'[Year]) gets the value selected in the slicer.
• ISBLANK(SELECTEDVALUE('Calendar'[Year])) checks if the slicer value is blank.
• MAX('Calendar'[Year]) gets the maximum year from your date table.

1. Use the Measure in Your Visuals: Apply this measure as a filter or use it directly in your visuals. For instance, if you have a visual that needs to be filtered by year, you can use the SelectedYear measure to ensure it always uses the maximum year when no year is selected in the slicer.

To apply this measure as a filter, you can use it in the Filter pane by setting it in the filter section of your visuals.

Here is an example of how you might use it in a visual calculation:

SalesAmountFiltered =
CALCULATE(
    SUM(Sales[SalesAmount]),
    'Calendar'[Year] = [SelectedYear]
)