Forum Discussion

sankaranks's avatar
sankaranks
Regular Visitor
9 years ago

Plotting events on a graph

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

Need Help

1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    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])