Forum Discussion
Vertical Date Line
Hi Anonymous ,
As a workaround, we can create a line chart and a date slicer to meet your requirements.
Create a line chart and drag the date column into the X-axis and the sales or other values into the Y-axis.
Then create a slicer and drag the date column into the slicer and you can change the style as required, select as many dates as required and the line chart will show the relevant values:
Note: Remember to disable the original visual interaction with the slicer, as shown below:
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
As a workaround, we can create a line chart and a date slicer to meet your requirements.
Create a line chart and drag the date column into the X-axis and the sales or other values into the Y-axis.
Then create a slicer and drag the date column into the slicer and you can change the style as required, select as many dates as required and the line chart will show the relevant values:
Note: Remember to disable the original visual interaction with the slicer, as shown below:
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Joyce, thanks ever so much for this. Its definitely a viable solution. The only problem here is the report has 2 scatter charts per page and there are at least 50 pages containing 2 scatter charts so i`d be looking at changing 100 visuals from scatter charts to line charts. I`ll duplicate one of the pages and apply your solution and see how long it takes. Thanks again.
Alan