Plotting events on a graph

[sankaranks]

I need to create a chart (Line or Bar) to show daily sales using the available dataset. But I also keep another table to store the dates of Weekly marketing campaigns. Now I want to highlight the daily sales chart with campaign dates (Possibly a bubble on the chart) to help analyzing the impact of marketing campaign in sales. 

Is that possible to do in Power BI. Please help

Sankaran

[Eric_Zhang]

@sankaranks

That sounds a good idea, however at this moment it is not supported in Power BI. You can  submit it at Power BI Ideas and vote it up.

The workaround can be using a stackedchart to compare the average or max values.

average sales for campaign days = AVERAGEX(FILTER(salesTable,CONTAINS(campaignDates,campaignDates[Date],salesTable[date])),salesTable[sales])

average sales for regular days = AVERAGEX(FILTER(salesTable,NOT(CONTAINS(campaignDates,campaignDates[Date],salesTable[date]))),salesTable[sales])