Forum Discussion

craigsmwhite's avatar
craigsmwhite
Frequent Visitor
3 years ago
Solved

Line Chart Scaling

Hi,

 

I have data within a chart which starts at a figure of 60% and increases/decreases daily over a 90 day range up to around 90%. 

 

What I'm after is havng a line chart which shows the same increases/decreases but that is on a scale of starting at 0% rather than 60% and maintains the new scale rather than jumping straight up to the higher number the following data point.

 

Is this doable and if so how would I go about it?

 

Thanks all,

 

Craig

Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi craigsmwhite ,

    I'm afraid you can't do that. Because nodes on the line chart represent its value to corresponding X-axis. If the value isn't 0, it can't starts at 0.

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    Hi craigsmwhite ,

    According to your description, I create a sample.

    When create a line chart, it starts at the minumum value 60%, because there is no value equals to 0.

    In order to starts at 0, you should create a seperate calendar table. 

    Table 2 =
CALENDAR ( DATE ( 2022, 6, 1 ), DATE ( 2022, 9, 15 ) )

    Then create a calculated column in the new table.

    Column =
VAR _Per =
    MAXX (
        FILTER ( 'Table', 'Table'[Date] = EARLIER ( 'Table 2'[Date] ) ),
        'Table'[Percentage]
    )
RETURN
    IF ( _Per = BLANK (), 0, _Per )

    Then get the consecutive change by date.

    I also attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • craigsmwhite's avatar
      craigsmwhite
      Frequent Visitor
      3 years ago

      Thank for you the reply v-yanjiang-msft.

       

      I'm not sure that's what I'm after and I also realised I missed another part of my request, apologies.

       

      What I would need is for it not to jump from 0 to 60 to 65. I'm after is the 60 being the starting point, so 0, and then the 65 then becoming an increase of 5. This way the increase remain the same but the scale has changed.

       

      If this is posdible, is there any way to have this so it's dynamic? Meaning if I was to pick a different start date on a slicer, it still starts from 0?

       

      If I use the table example you gave, what I'm after is being able to have the chart starting at 0 whether I picked 07/01 or 07/15 or 08/01.

      • v-yanjiang-msft's avatar
        v-yanjiang-msft
        Community Support
        3 years ago

        Hi craigsmwhite ,

        I'm afraid you can't do that. Because nodes on the line chart represent its value to corresponding X-axis. If the value isn't 0, it can't starts at 0.

        Best Regards,
        Community Support Team _ kalyj

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.