Hi @Simomazzi , Thank you for reaching out to the Microsoft Community Forum.
This happens because Power BI tries to find data that matches both date ranges at once, which isn’t possible when they don’t overlap, leaving your slicer empty. create a disconnected date table to handle your date range slicers. Don’t connect this table to your fact table. This keeps the date selections independent. This table won’t link directly to your data, which prevents the filtering issue. Example:
DisconnectedDate = CALENDAR(DATE(2020, 1, 1), DATE(2025, 12, 31))
Next, add two slicers to your report, both using DisconnectedDate[Date]. Label them something like “Date Range 1” and “Date Range 2” and set them to Between mode for easy range selection. These slicers will let users pick the time periods they want to compare, like January 2023 and June 2023. Now, create measures to calculate your metric for each date range. Use TREATAS to apply the slicer selections without messing up other filters. Example:
Sales_DateRange1 =
CALCULATE(
SUM(Sales[Amount]),
TREATAS(VALUES(DisconnectedDate[Date]), Sales[Date])
)
Sales_DateRange2 =
CALCULATE(
SUM(Sales[Amount]),
TREATAS(VALUES(DisconnectedDate[Date]), Sales[Date])
)
To keep the Marketplace slicer populated, create a measure that lists all marketplaces with data in either date range. Example:
MarketplaceFilter =
VAR MarketsInRange1 =
CALCULATETABLE(
VALUES(Sales[Marketplace]),
TREATAS(VALUES(DisconnectedDate[Date]), Sales[Date])
)
VAR MarketsInRange2 =
CALCULATETABLE(
VALUES(Sales[Marketplace]),
TREATAS(VALUES(DisconnectedDate[Date]), Sales[Date])
)
RETURN
COUNTROWS(UNION(MarketsInRange1, MarketsInRange2))
Then, add your Sales[Marketplace] field to a slicer. In the slicer’s Visual-level filters, drag in MarketplaceFilter and set it to is not blank. This ensures the slicer shows all marketplaces from either date range, even if the ranges don’t overlap. Finally, use your measures in visuals like tables or charts to compare Sales_DateRange1 and Sales_DateRange2. If you want a combined view, create TotalSales. Example:
TotalSales = [Sales_DateRange1] + [Sales_DateRange2]
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
