Forum Discussion
Show Changes in Month without resuming x axis datetime data
Hi I have this dispersion graph every dot represents a datetimezone datatype on x axis. I want to just show changes in months in x axis. For example this would be nice to accomplish as x-axis data in order to being able to visualize changing in month but without lossing the visibility of the data (without resuming). I just put the data below the graph I want to hide
This is how I want to show the info. I know I can hide x-axis with the toggle option but I dont know how to add the dates as shownm below
01/05/2021 01/06/2021 01/07/2021
Any tip would be really appreciated
4 Replies
- mahoneypat
Microsoft Employee
Do you have your x-axis set as categorical or continuous? If categorical, try switching that first.
Pat
- AnonymousNot applicable
Hi mahoneypat. I dont know why but my x-axis do not show me that option.
X- axis ( Color, Font size, Font family, Width of minimum category, Maximum size, Internal space, Title )
Any clarification would be really appreciated. Perhaps I need to do something with the data before, in order enable that feature but I don´t know what exactly is needed.
Thank for your help,
Julio
- mahoneypat
Microsoft Employee
You are looking in the right place if you are using a line chart. What type of chart are you using? Also, is the column used on the x-axis set to Date data type?
Pat
- AnonymousNot applicable
mahoneypat actually is a Dispersion Graph and my x-axis is DateTimeZone datatype