Issue in filtering

Hi chaitanya1 ,

You're facing a common filter behavior issue in Power BI where a table visual goes blank when a date is selected, despite everything else working as expected. This typically happens when there's a default logic hardcoded somewhere (like "yesterday's data") that's clashing with the slicer selection. To handle this correctly, you need a DAX measure that smartly switches between showing yesterday’s data by default and the user-selected date when available. You can create a measure like this:

SelectedOrDefaultDate =
VAR SelectedDate = SELECTEDVALUE(DimDate[Date])
RETURN
IF (
    ISBLANK(SelectedDate),
    TODAY() - 1,
    SelectedDate
)

This measure checks if the user selected a date. If not, it defaults to yesterday’s date using TODAY() - 1. Then, in your table visual, instead of filtering directly on the date column, you apply this logic through a measure like:

SalesForDate =
CALCULATE (
    [YourMetricMeasure],
    DimDate[Date] = [SelectedOrDefaultDate]
)

Replace [YourMetricMeasure] with your actual measure, such as SUM(Sales[Amount]) or similar. Use this SalesForDate measure in your table visual instead of relying on direct filtering. This way, the table shows yesterday’s data by default and updates correctly when the user selects a date from the filter. If the table is still blank, double-check your relationships, visual-level filters, or confirm the DimDate table includes the date in question.

Best regards,