cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lorien Frequent Visitor
Frequent Visitor

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 Period.JPGCampaign 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.

 

Conversion Rate Info.JPGSplicer 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.

4 REPLIES 4
Super User
Super User

Re: Dates / Splicers

Hi,

 

Share some data and show the expected result.

Lorien Frequent Visitor
Frequent Visitor

Re: Dates / Splicers

Hi @Ashish_Mathur

Correct Current month not with Campaign Splicer.JPGCorrect current month not using campaign splicerIncorrect Current month with Campaign Splicer.JPGIncorrect current month using the campaign splicerCorrect Previous three month period not with Campaign Splicer.JPGCorrect three month period not using campaign splicerIncorrect Previous three month period with Campaign Splicer.JPGIncorrect three month period using campaign splicer

Please note there is some missing data from the current months as we have some consultants who have not registered on the board yet.

 

Also I need to use the campaign splicer as it is referenced in measured to calculate the differences.

Super User
Super User

Re: Dates / Splicers

Hi,

 

I do not understand your result.  Share the link from where i can download your PBI file and more importantly show your expected result there.

Lorien Frequent Visitor
Frequent Visitor

Re: Dates / Splicers

Unfortunately I can't share the file sorry as it contains sensitive company information.

 

I really appreciated your help though is there something else I can provide to you to help you understand?