grouping labels on x axis

[powerbiexpert22]

is it possible to show group lables on x axis like below highlighted 

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

In calendar_dimension table, I tried to create Group Quarter-Year calculated column and Group Quarter-Year sort calculated column.

Group Quarter-Year = 
VAR _today =
    TODAY ()
VAR _indexquarteryear =
    ROWNUMBER (
        VALUES ( calendar_dim[End of Quarter] ),
        ORDERBY ( calendar_dim[End of Quarter], ASC )
    )
VAR _todayindex =
    MAXX (
        FILTER (
            ADDCOLUMNS (
                calendar_dim,
                "@indexquarteryear",
                    ROWNUMBER (
                        VALUES ( calendar_dim[End of Quarter] ),
                        ORDERBY ( calendar_dim[End of Quarter], ASC )
                    )
            ),
            calendar_dim[date] = _today
        ),
        [@indexquarteryear]
    )
RETURN
    SWITCH (
        TRUE (),
        _indexquarteryear <= _todayindex
            && _indexquarteryear >= _todayindex - 2, "Current Engagement",
        _indexquarteryear <= _todayindex - 3
            && _indexquarteryear >= _todayindex - 5, "Initial Interactions",
        _indexquarteryear <= _todayindex - 6, "Purchased",
        _indexquarteryear > _todayindex, "Future ML prediction",
        "Check again"
    )

Group Quarter-Year sort = 
VAR _today =
    TODAY ()
VAR _indexquarteryear =
    ROWNUMBER (
        VALUES ( calendar_dim[End of Quarter] ),
        ORDERBY ( calendar_dim[End of Quarter], ASC )
    )
VAR _todayindex =
    MAXX (
        FILTER (
            ADDCOLUMNS (
                calendar_dim,
                "@indexquarteryear",
                    ROWNUMBER (
                        VALUES ( calendar_dim[End of Quarter] ),
                        ORDERBY ( calendar_dim[End of Quarter], ASC )
                    )
            ),
            calendar_dim[date] = _today
        ),
        [@indexquarteryear]
    )
RETURN
    SWITCH (
        TRUE (),
        _indexquarteryear <= _todayindex
            && _indexquarteryear >= _todayindex - 2, 0,
        _indexquarteryear <= _todayindex - 3
            && _indexquarteryear >= _todayindex - 5, -1,
        _indexquarteryear <= _todayindex - 6, -2,
        _indexquarteryear > _todayindex, 1,
        100
    )

[danextian]

Hi @powerbiexpert22 ,

In what way do you want the label to grouped? For example, for initial purchase which has two quarters, there is just a single label?

[powerbiexpert22]

Hi @danextian , sorry i should not use the word group however this is what i wanted to acheive