Count over date axis

[irnm8dn]

Looking for a suggestion.

Within my dataset, I have hundreds of customer campaigns - each with a distinct name and a campaign creation date.

I am trying to represent campaign count by day, month, year so that I can look at performance day-over-day, MOM and YOY. 

I am using a  date table as well, but can't seem to have the visual show the proper count of campaign name in a bar or line with a date axis.  I have used both campaign creation date as well as the date table, but neither seems to show the results I was expecting to see.

Is there anyone who has a suggestion how I can get the campaign count over a date axis?

[v-jiascu-msft]

Hi @irnm8dn,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[TomMartens · Accepted solution]

Hey,

I'm wondering what's not working.

I understood

• Many different campaigns can be created at the same day

Assumption

• Your date table is related with your "campaign" table:  datetable (one) - campaign (many)
• both date columns have the same datatype (ideally date) and not datetime, if one or both are datetime you have to ensure that the CreatedDate column is not the creation date from the source system containing a specific time. This would most likely result in weird results --> convert datetime columns into date columns if the time information provides no addition insight

Expectation

Using the date column from the date table on the xaxis of your chart and the campaign name as value (by default the aggregation type COUNT is chosen by Power BI) I would expect the correct number of campaigns created on each day.

Maybe you can describe what you see, the better share sample data, and make this data available as download.

Without any further information it's difficult not to say almost impossible to provide further information

Cheers