Forecasting
Thanks for the great visual.
I am getting weird x Axis (date) labels. 2016.2, 2016.4 and they don't seem to line up with February 2016 and April 2016. Attached is a png image of what i am seeing. I also included a standard pbi visual to show the correct dates.
Am I missing a formatting option?
- mjc9 years agoFrequent Visitor
Attached is a copy of the actual data used in the original births.csv file which I obtained from the pbix.
I got this by simply creating a new table on the report page, added all columns with no summarisation then used the export data option from that table.
As dates are exported from Power BI using a date-time format I used excel to reformat the Calendar Month column as just a date. I deliberately used a US format (mm//dd/yyyy) which might be more widely usable though this should automatically be recognised by Power BI anyway. If it is not and you use something different then just format in excel to suit your needs.
Obvioulsy this doesn't really gain you anything since the information was all already embedded in the pbix but it does allow you to fix the errors seen when looking at queries.
Of course, the technique is something that might be useful in other situations where you are missing a source file and want to recreate it so hopefully this helps someone.
(attached as a zip file since csv attachments are not supported on the forum)