Need help with management dashboard workorders

Hi kv41282,

According to your statement, I think your requirement is to show dynamic X axis like Year-Month/Year-Week/Year and so on.

As far as I know, you can create a DimDate table and relate it with your data table by [Date] column.

DimDate =
ADDCOLUMNS (
    CALENDARAUTO (),
    "Year", YEAR ( [Date] ),
    "Month", FORMAT ( [Date], "MMM" ),
    "MonthSort", MONTH ( [Date] ),
    "WeekNum", WEEKNUM ( [Date], 2 ),
    "YearMonth", FORMAT ( [Date], "YYYY-MMM" ),
    "YearMonthSort",
        YEAR ( [Date] ) * 100
            + MONTH ( [Date] ),
    "YearWeek",
        FORMAT ( [Date], "YYYY" ) & "-" & "Week" & ""
            & WEEKNUM ( [Date], 2 ),
    "YearWeekSort",
        YEAR ( [Date] ) * 100
            + WEEKNUM ( [Date], 2 )
)

My Sample:

Then you can use Field parameter to achieve your goal.

For reference: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Result is as below.

Best Regards,
Rico Zhou

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