Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Extend the X axis beyond week start date

Hi All,

 

I have an requirtment to show line graph x axis values beyond week start date .

For example i have a simple data set

 

DateAmtWeek Start
04/01/20206103/28/2020
04/02/20206203/28/2020
04/03/20206303/28/2020
04/04/20206403/28/2020
04/05/20206503/28/2020
04/06/20206604/04/2020
04/07/20206704/04/2020
04/08/20206804/04/2020
04/09/20206904/04/2020
04/10/20207004/04/2020
04/11/20207104/04/2020
04/12/20207204/04/2020
04/13/20207304/11/2020
04/14/20207404/11/2020
04/15/20207504/11/2020
04/16/20207604/11/2020
04/17/20207704/11/2020
04/18/20207804/11/2020
04/19/20207904/11/2020
04/20/20208004/18/2020
04/21/20208104/18/2020
04/22/20208204/18/2020
04/23/20208304/18/2020
04/24/20208404/18/2020
04/25/20208504/18/2020
04/26/20208604/18/2020
04/27/20208704/25/2020
04/28/20208804/25/2020
04/29/20208904/25/2020
04/30/20209004/25/2020

 

I need to develop a line chart which will have x axis showing Week start and Amt in values.

Untill this i have done but here when i add Date column in visual filter and filter till "4/22/2020" the graph stops showing data untill "4/18/2020" but i need to  extend of line beyond "4/18/2020" and show till "4/22/2020"  as per the filter condition.

 

As "4/22/2020" is not avalibale in Week start columns its ok if that value doesnt shown up in x axis  but i need the line extended till "4/22/2020" and on hover show tooltip values.Attached screenshot for reference .

Thanks

 
Need Help
Show and Tell
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    It is impossible to extend the line, however you could add a tooltip page over data points.

    When hovering on the data point, it pops out a line chart which show the detailed dates every week.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous 

    It is impossible to extend the line, however you could add a tooltip page over data points.

    When hovering on the data point, it pops out a line chart which show the detailed dates every week.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-juanli-msft ,

       

      Thanks for the input.

      I had thought of this tooltip but wanted to check if any work around of possible.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    You are going to need any date that shows up on the x-axis in the data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Greg_Deckler ,

       

      Thanks for your time.

       

      I need to have week start dates in x axis untill  "4/18/2020" .

       

      Trying to explain the problem statement once again

       

      If i add a visual filter till "4/22/2020" the graph stops showing data untill "4/18/2020" but i need the line to  extend  beyond "4/18/2020" and show till "4/22/2020"  as per the filter condition.

       

      As "4/22/2020" is not avalibale in Week start columns its okay if that value(4/22/2020) doesnt shown up in x axis and show untill  "4/18/2020" but i need the line extended  and on hover show tooltip values show "4/22/2020".