I have a PowerBI report with a line chart that shows average costs over a time period. The time period is based on a date that is set to use a date hierarchy for the year and the month.
When I open the report the line chart does not display correctly. The lines are incorrectly flat.
If I change the date from a date hierarchy to just the date and then back to the hierarchy, then it displays correctly.
This also happened when I published the report to the PBI service. What can be done to negate the need to do this?
I have tried resetting the field for the X-axis and restarting the application.
Clicking on the double arrow icon to expand the next level by default resolved my issue.