Line Chart Scaling

[craigsmwhite]

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

[craigsmwhite]

@v-yanjiang-msft thanks for confrirming and your help.

[v-yanjiang-msft]

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]

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 · Accepted solution]

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.