Reference Line on x-axis

[bluestonewales]

Hi, I am looking to draw a reference line on the x axis of a chart whcih range from -70 weeks to 0 weeks. I can work out where the reference should be (it varies dynamically based upon slicer selection and today's date). In the first case I have a measure that shows the value -14 as a card but need this to be a vertical line that as time progresses would move along the axis to 0

Any help would be greatly appreciated.

Thanks

Simon

[v-yuta-msft]

Hi bluestonewales,

Could you please share some sample data or some screenshots, and explain more details about your requirement?

Regards,

Jimmy Tao

[bluestonewales]

The charts above are based upon a series of filters and represent a specific product (label filter) ona specific date (choosen by financial period, financial period week number and break type which is either a friday or monday). The effect of all of the filtessr is to choose a specific date (for each year) and I show the data relating to that date for 2018 and 2019. The x axis for both charts ranges from -70 to 0. I have built a measure that calculates how many weeks out from the 2019 date we are and this is shown in a card bottom right (shown as -14).

Ideally I am looking for a red line that shows an x axis at -14 but that would vary depending on the measure. It can be a different visual sitting on top of the other charts.

Any help would be appreciated.

Simon