Filtering report using USERELATIONSHIP measures with Charts

Hi Anonymous 

It is indeed possible to filter both charts using a calendar table in Power BI, and there is no need to delete the calendar table. Using a calendar table is recommended as it allows date fields to be consistent throughout the model and simplifies time intelligence calculations.

Here's a step-by-step guide to help you set up filtering:

Make sure your calendar is set up correctly:

Make sure your calendar table contains all the dates you may need for the Document Date and Delivery Date fields.

Check if the calendar table is marked as a date table in the model.

Build relationships:

Define the relationship between the calendar table and the table containing Document Date and Delivery Date. These should generally be one-to-many relationships, with one side on the calendar table.

Filter using calendar:

In the report, add a slicer and use the date field from the calendar table as the slicer's field.

Configure the slicer to filter by an appropriate date range or selection.

Make sure cross filtering is enabled:

If necessary, adjust the cross-filtering direction in the relationship to ensure that selecting dates in the slicer filters the data in both charts.

Verify filter propagation:

Test the slicer to verify that selecting a date range updates both charts accordingly.

Model relationships in Power BI Desktop - Power BI | Microsoft Learn

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.