Adjusting X-axis range for every Other Day, rather than Every Day !

[F_Reh]

Good afternoon,

I wish to reduce the points on the following graph (snippet shown) because he X-axis is extremely busy & cluttered, and was wondering if its possible to adjust it so that it only shows points for every other day (instead).

Kindly advise.

Regards

[AlexTheGreat · Accepted solution]

Hi,

You could change the type to "Continuous"
To do this you go to Visual > X-axis > Type > Continuous instead of Categorical

An other way to do this is to create a measure that for example only shows even numbers:

ShowDate = IF(MOD(DAY([Date]), 2) = 0, FORMAT([Date], "dd-mm"), BLANK())

 Change the number (2) into something else if you need even less. If you use the measure make sure you use the type "Categorical"

Hope it helps!

[v-echaithra]

Hi @F_Reh ,

We wanted to follow up to see if the issue you reported has been fully resolved. If you still have any concerns or need additional support, please don’t hesitate to let us know, we’re here to help.

We truly appreciate your patience and look forward to assisting you further if needed.

Warm regards,
Chaithra E.

[v-echaithra]

Hi @F_Reh ,

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.

[v-echaithra]

Hi @F_Reh ,

Thank you @martinson , @AlexTheGreat  for your inputs.
We would like to confirm if you've successfully resolved this issue or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.

[martinson · Accepted solution]

Hi there H_Reh,

Changing the x-axis to continuous would help declutter the labels on the x-axis, but it wouldn't solve the point/marker problem. To do this, I would recommend creating a new measure that averages the values over 2 days and putting a filter on the visual to reduce the point density (using the method shared by AlexTheGreat).

[AlexTheGreat · Accepted solution]

Hi,

You could change the type to "Continuous"
To do this you go to Visual > X-axis > Type > Continuous instead of Categorical

An other way to do this is to create a measure that for example only shows even numbers:

ShowDate = IF(MOD(DAY([Date]), 2) = 0, FORMAT([Date], "dd-mm"), BLANK())

 Change the number (2) into something else if you need even less. If you use the measure make sure you use the type "Categorical"

Hope it helps!