Additional markers on continous ytd line

[gumis_rulez]

How to add additional markers which will reflect choosen date from a slicer?

Like on the below example; when I choose 2018-11-13, marker should appear on the level of continues ytd line, indicating sales for this month.

dasd

Link to the file:

https://drive.google.com/file/d/1SF7lvSP9TuHM81JZZtjKXVzXudnRc-0D/view?usp=sharing 

[OwenAuger · Accepted solution]

Hi @gumis_rulez 

Here's one suggestion (updated PBIX attached):

1. Enable interactions between the DateParameter slicer and the line chart.

2. Create this measure, which returns [Total Sales Continuous YTD] at Date From & Date To.

Total Sales Data Label Points = 
VAR LabelDates = { [Date From], [Date To] }
VAR CurrentDate =
    MAX ( dimCalendar[Date] ) -- assume dimCalendar[Date] on axis
VAR Result =
    IF (
        CurrentDate IN LabelDates,
        [Total Sales Continuous YTD]
    )
RETURN
    Result

3. Include [Total Sales Data Label Points] as an additional Y-axis field.

4. For series Total Sales Data Label Points,

 (a) Turn on Data Labels

 (b) Set Data Labels Value to Total Sales.

 (c) Turn off Lines

 (d) Turn on Markers