Clustered Column Chart Data Selection

Hey bdehning 

Yes, you can achieve this by modifying the interaction between your slicer and the clustered column chart. Here's how you can set it up:

1. Keep the slicer as it is, allowing users to select any year, even those outside the last 60 months.

2. In the clustered column chart visual, use a measure that dynamically calculates the last 60 months of data based on the selected year in the slicer.

Here's an example of how you can create such a measure in DAX:

Last_60_Months_Data =
VAR Selected_Year = SELECTEDVALUE('Your_Slicer_Table'[Year_Column])
VAR Max_Date = DATE(YEAR(TODAY()), MONTH(TODAY()), DAY(TODAY()))
VAR Min_Date = DATE(Selected_Year - 4, 1, 1) // Assuming 60 months is 5 years

RETURN
CALCULATE(
[Your_Measure],
FILTER(
'Your_Date_Table',
'Your_Date_Table'[Date_Column] >= Min_Date &&
'Your_Date_Table'[Date_Column] <= Max_Date
)
)

Replace 'Your_Slicer_Table'[Year_Column] with the appropriate columns from your slicer table, and replace 'Your_Measure', 'Your_Date_Table', and 'Your_Date_Column' with the names of your measure, date table, and date column, respectively.

With this measure, the clustered column chart will dynamically adjust to show the last 60 months of data based on the selected year in the slicer, allowing users to select any year without making the visual blank.

Hi,

I am not clear about what you want.  Do you want to show the total sales for ech of the past 60 months ended the month select by the user in the slicer.  So if a user selects Jan 2024, then there should be 60 columns in the column chart ending in Jan 2024?