Hide 0 from X axis in continuous order while there is no 0 in data

[Jyotisha]

Hi, I need to plot test values vs Study Days for multiple patients in scatter plot. Showing test names in filter. There are negative studydays as well and
no possibility of '0' study. Patient Id need to use in legends Study days can be only in -ve and +ve numbers. But when I'm ploting it by keeping X-axis in continuous,
It's showing 0 study days and when trying with catogorical, study day is not coming in order.
Is there any way to plot study day in X-axis in order without showing 0.
Please refer the attachments.

Thanks

[v-lid-msft]

Hi @Jyotisha ,

Are you using the Scatter chart ? Could you please try to change the range of Y-Axis from 0.2 to 1, it will make the chart more clearly.

Best regards,

[Jyotisha]

Hi @v-lid-msft , 

Actually the axis value varies test to tests. And there are various tests, provided in the filter. So we cannot fix the axis.

[v-lid-msft]

Hi @Jyotisha ,

Sorry for delay in response, in the scatter chart, the x-axis will group by the legend first, we can try to use a line chart wiout line as a workaround:

Best regards,

[Anonymous]

That's such a random order for the X-Axis to display!

Can you check that the Study Day data type is set to "Number" rather than text.

Also, check the "Sort By Column" option to make sure it's not being sorted by a different column.

[Jyotisha]

Hi @Anonymous ,

Appreciate your quick response.

Data type of Study Day is Whole number only. I have also checked "Sort By Column" option but It's not affecting it.

[Anonymous]

Hi @Jyotisha,

Have your tried chaning your X Axis from type Continuous to type Categorical (looking at the second screenshot here)?

Logically speaking, when traversing from negative values across to positive values, zero is a very relevant reference point.

Based on your screenshots, it's clear to me that despite the fact zero is shown on the axis, there are no data points attributed to it.

Cheers,

Andy

Edit: Spelling

[Jyotisha]

Hi @Anonymous , 

Appreciate your quick response.

I also tried the same but then study days are not sorting on order. Please have a look on attachmet for categorical.

[v-lid-msft]

Hi @Jyotisha ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[Jyotisha]

Hi @Anonymous ,

Appreciate your quick response.
As We are considering the ​test results from the past when we didn't start the study. study day 1 is considered from the day we are starting study. So practically there is no possibility of 0 studydays. And I need to show studydays in ascending order only.