Manipulate date slicer behaviour with Graph visual

Hi AshishTanwar88 ,

To achieve the desired behavior in Power BI, where the date slicer dynamically adjusts based on the last available data date, you can use a combination of DAX measures and a calculated table. Start by creating a DAX measure to identify the last date with data available. This can be done using the formula:

LastAvailableDate = 
CALCULATE(
    MAX('YourTable'[Date]),
    NOT(ISBLANK('YourTable'[Value]))
)

Here, replace [Value] with the column that determines whether data exists for a given date. This measure finds the maximum date in your dataset where data is available.

Next, create a calculated table that generates a dynamic three-day date range ending on the last available data date. Use the following formula:

DynamicDateRange = 
ADDCOLUMNS(
    CALENDAR(
        DATEADD([LastAvailableDate], -2, DAY), 
        [LastAvailableDate]
    ),
    "DisplayDate", FORMAT([Date], "MM/DD/YYYY")
)

This table ensures the three-day window adjusts dynamically based on the last available date. Then, link the DynamicDateRange table to your main table using the Date column, and use the DynamicDateRange[Date] as the slicer field in your report.

To ensure the slicer dynamically displays the correct date range, you can modify the visual title or slicer label to reflect the range. Create a DAX measure like this:

SelectedDateRange = 
VAR StartDate = MIN(DynamicDateRange[Date])
VAR EndDate = MAX(DynamicDateRange[Date])
RETURN
"Selected Range: " & FORMAT(StartDate, "MM/DD/YYYY") & " to " & FORMAT(EndDate, "MM/DD/YYYY")

This measure dynamically updates the displayed range based on the adjusted slicer selection. By using this setup, your slicer and graph will adjust to show data for the last three days based on the most recent available date, ensuring accurate and dynamic visuals even when the latest data is unavailable.

Best regards,