Forum Discussion
Create scatter chart with date on x axis
You can set the display format of your date in the 'Modeling' ribbon menu under Data Format, to determine how the date will be displayed in visuals.
If your concern is the default date hierarchy that is generated when adding a date to an axis, you can choose to display just the date. Some reading on this feature.
- teylyn10 years agoAdvocate III
This sounds logical, but I'm running into the same problem. My date is formatted in the model and set to "Do not Summarize".
But on the X axis of the Scatter plot it shows as "Count of date". The only thing I can change is set it to distinct count. It does not show the date hierarchy either.
Any ideas?
- greggyb10 years agoResident Rockstar
For future searchers - another thread where this got covered: http://community.powerbi.com/t5/Desktop/Scatter-with-date-on-X-and-time-on-Y/m-p/19030