'Is it possible to display dates in power query as MMM/YY and keep it as a date format instead of text?
My problem is that I generated a pivot chart that is showing the axis values as DD/MM/YYYY. I changed the date format for the relevant column in the power pivot manager to MMM/YY and it looks fine in there, it's displayed correctly in the pivot table as well, but not on the chart axis. I'm guessing it's because in the main query the format is stuck as DD/MM/YYYY. I also tried to format the axis to a number & date in the chart, but it doesn't react. Can anyone help please?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|