Forum Discussion

bluestonewales's avatar
bluestonewales
Frequent Visitor
7 years ago

Reference Line on x-axis

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

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi bluestonewales,

     

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

     

    Regards,

    Jimmy Tao

    • bluestonewales's avatar
      bluestonewales
      Frequent Visitor
      7 years ago

      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