Power BI两组6个月数据对比图表与DAX计算问题求助

数据对比范围 #

• 2024年4月至2024年9月
• 2024年10月至2025年3月

已创建的DAX度量值 #

In Season #

In Season = 
CALCULATE(
    SUM('Compare'[Seasonality]),
    FILTER(
        'Compare',
        'Compare'[date] >= DATE(2024,10,1) &&
        'Compare'[date] <= DATE(2025,3,31)
    )
)

Out of season #

Out of season = 
CALCULATE(
    SUM('Compare'[Seasonality]),
    FILTER(
        'Compare',
        'Compare'[date] >= DATE(2024,4,1) &&
        'Compare'[date] <= DATE(2024,9,30)
    )
)

遇到的问题 #

1. 聚类柱形图无法按“4月对10月”这类对应关系展示数据
2. 希望在表格中仅显示2024年10月至2025年3月的日期，并通过In Season - Out of Season计算差值

（注：原问题附带图片，因StackOverflow图片上传故障无法正常显示）

编辑补充内容 #

尝试将起始月份改为5月后未成功，使用的DAX代码如下：

vs_Date_names = 
    SWITCH(TRUE(),
        /* Out of Season */
        MONTH('Compare'[date]) = 5 && YEAR('Compare'[date]) = 2024, "1st month: May 2024 vs Nov 2024",
        MONTH('Compare'[date]) = 6 && YEAR('Compare'[date]) = 2024, "2st month: Apr 2024 vs Dec 2024",
        MONTH('Compare'[date]) = 7 && YEAR('Compare'[date]) = 2024, "3st month: Jun 2024 vs Jan 2025",
        MONTH('Compare'[date]) = 8 && YEAR('Compare'[date]) = 2024, "4st month: Jul 2024 vs Feb 2025",
        MONTH('Compare'[date]) = 9 && YEAR('Compare'[date]) = 2024, "5st month: Aug 2024 vs Mar 2025",
        MONTH('Compare'[date]) = 10 && YEAR('Compare'[date]) = 2024, "6st month: Sep 2024 vs Apr 2025",

        /* In of Season */
        MONTH('Compare'[date]) = 11 && YEAR('Compare'[date]) = 2024, "1st month: May 2024 vs Nov 2024",
        MONTH('Compare'[date]) = 12 && YEAR('Compare'[date]) = 2024, "2st month: Apr 2024 vs Dec 2024",
        MONTH('Compare'[date]) = 1 && YEAR('Compare'[date]) = 2025, "3st month: Jun 2024 vs Jan 2025",
        MONTH('Compare'[date]) = 2 && YEAR('Compare'[date]) = 2025, "4st month: Jul 2024 vs Feb 2025",
        MONTH('Compare'[date]) = 3 && YEAR('Compare'[date]) = 2025, "5st month: Aug 2024 vs Mar 2025",
        MONTH('Compare'[date]) = 4 && YEAR('Compare'[date]) = 2025, "6st month: Sep 2024 vs Apr 2025"
    )

目前不清楚为何会出现空白柱形。

内容的提问来源于stack exchange，提问作者Francesco Mantovani