clustered column help

Hi Bubbles ,

Categorical data with clustered columns and  sparse data across multiple measures leads to "empty category" spacing issues — Power BI will still allocate space for every combination.

Use a measure that returns Blank() for unwanted categories.

Ensure that forecast measures  return absolutely nothing (BLANK) for earlier years.
Try:

VAR IsFuture = SELECTEDVALUE('calendar'[FYIndexCAL]) > MAX('calendar'[today_Yr_flag])

RETURN
IF(IsFuture,
Q1Actuals + Q2 + Q3 + Q4,
BLANK()
)

You can even try: Line/column combo chart

Line charts handle sparse data points gracefully

• Plot Actuals as columns,

• Plot Forecasts (2Yr, 3Yr, 5Yr) as lines,

• Use a single continuous time axis (e.g., year + quarter)

Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!