Hi community,
I have a line chart with a trend line.
In the x axis I have date, and a measure like Total Sales in the y axis.
I have different stores and I would like to add a milestone in the x axis for the first date of a sale for each store.
The milestone could be a dot, a column, a line, anything and should link to the store names and ideally have a legend that shows them.
I'm not using constant lines becasue they do not allow me to filter the visual with the date slicer. Meaning that the visual even when filtered to a specific date range and the line adjusts to that filter, it always shows the entire x axis. Also I cant link the constant lines to the store names.
I would prefer to keep the trend lines as well, but if thats not possible then I can live with that.
Any suggestions? New tables, other visuals etc?
Thanks.
