custom X-axis

eduardo

According to your description, you want to compare same campaign last year(similar to YOY comparisons). Right?

The axis is from the data field in your dataset, you can’t custom axis unless you create a column with all your custom values and put it onto axis. In this scenario, you should still use complete date as X-axis and display two campaigns data together, you can use DATEADD and DATEDIFF function to dynamically get correct days back since two campaigns may have different start date and duration.

The formula below is for your reference.

CPA 2015.1 =
CALCULATE (
    [CPA],
    dados[Conta] = IdCampanha[Conta]
        && IdCampanha[2015.1_I] <> BLANK ()
        && dados[Dia] >= IdCampanha[2015.1_I]
        && dados[Dia] <= IdCampanha[2015.1_F]
)

CPA 2016.1 =
CALCULATE (
    [CPA],
    dados[Conta] = IdCampanha[Conta]
        && IdCampanha[2016.1_I] <> BLANK (),
    DATEADD (
        dados[Dia],
        DATEDIFF (
            MAX ( ALL ( IdCampanha[2015.1_I] ) ),
            MAX ( ALL ( IdCampanha[2016.1_I] ) ),
            DAY
        ),
        DAY
    )
)
 

Regards