Forum Discussion
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 dai...
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])