Forum Discussion
Line Chart with Events
I have a simple line chart that charts POS Sales over time. I have another table that breaks out all US Holidays with their date. I would like to use the US Holidays Table to have Events layered over my Line Chart (See below). Is this possible, either in a standard visual or an Imported Visual?
Current Visual:
Desired Outcome:
Thanks!
11 Replies
Anonymous you can surely do that, add a measure where date = holiday date otherwise return blank, and then use a combo bar and line chart and use this measure for the bar chart, alternatively, you can also explore error bars.
Anonymous you can surely show the data labels using custom data labels by creating a measure, that shouldn't be the issue. Did you try error bars?
Anonymous with error bars you can get this skinny line:
Anonymous error bar setting is to share skinny line, not for the label, dynamic label is in the data label section. Maybe easier if you share pbix file with the sample data and I will put together something for you.
That would be hugely appreciated, thank you! Here is a Dropbox link to the sample file: https://www.dropbox.com/scl/fi/8hdigbhxj1vm14wobpt8s/Error-Bars-Sample.pbix?rlkey=s63d2azw4wvjwf1867fp4s0ea&dl=0
Anonymous quick question for you, do you want to show the bar when there is a holiday but no sales, for example in the pbix file you shared, Jan 1 is a holiday but there are no sales for that day, the solution is going to be different based on your answer. I assume you don't want to show the bar but want to confirm.
Anonymous hmmm, in my opinion not a good approach, reason behind that is you will see holidays thru out the year and when don't have a sales you will have broken POS sales line which I don't think will look nice or good.
I understand what you mean. The reason I wanted to show holidays when there is no POS Sales is because in our database, we report POS Sales for the week by Week End Date so a holiday could be in the middle of a week and not necessarily on the day shown for the Week End Date. Is it easy to showcase this both ways?
