I also found this: which is proving helpful and may be of use to others. I did make an attempt at the Query Editor but kept getting error messages and I don't know enough at the M syntax to work my way out of it - will go and do some reading though.
I’ve also changed the axis layout so you don’t have. Right-click (Excel 2007) or double click (Excel 2010+) the axis to open the Format Axis dialog box > Axis Options > Text Axis: Now your chart skips the missing dates (see below). I have to go through our IT department to get them to update or reinstall the software so am loathe to do that unless it is absolutely necessary, I checked on a different computer which had PowerBI installed after me and I see the same date format options on that machine too, so I don't think it can be a version control issue, although it doesn't make sense that different formats are available to different people? If you want Excel to omit the weekend/missing dates from the axis you can change the axis to a ‘Text Axis’. 421 64-bit (June 2018)) which I think is the most updated version.
I have the June 2018 version of PowerBI (Version.
0 kommentar(er)
