Forum Discussion
How create relationship from one tab to other,
Hi Bansi008
To view the last 5 years of data from the selected date, you’ll need to use a disconnected table. Using a column from a related table will only display data for the selected value. For example, selecting January 2025 will limit the visible rows to January 2025. Although you can modify the filter context through a measure to show values outside the selected range (e.g., the last 5 years), the visible rows will still be restricted to the selected dates. To resolve this, create measures referencing the disconnected table—one for the selected period and another for the last X periods. Place the column from the disconnected table in a slicer and sync it across the two pages.
Note: that my sample has less than two years worth of data so only last 12 months is shown.
Please see the attached pbix.