Dates / Splicers

Hi everyone,

Please excuse the non-tech lingo as I am not a Power BI expert. I will try to explain what I am trying to acheive the best I can.

What we are trying to do is show the current month's sales, GP and conversion rates and also display the averages from the previous three month "campaign period" and then show the difference in % percentage between the current month (which will need to sum the three months as we move through the campaign period) with the previous campaign period. I want this all in the same visualisation.

I have a table set up for campaign periods, as you can see below the campaign period is quarterly and is set to a text type because if I try to set it as a date type returns an error message.

Campaign Range

This works fine when I apply a splicer with the Campaign Range "text" for my sales data (all information pulls from our SQL Server.) It returns the right month and compares it with thre previous three month campaign period.

However when I try to apply it to our conversion rates (which pulls from an API) it pulls in previous years and months into the conversion rate for the current month and is not calculating the previous months conversion rates correctly either.

Splicer and Data Returned

Can anyone please help me get around this? I do not want it to affect the sales data which is to the best of my knowledge working fine.

Thanks.