Data not shown correctly on line graph

[moezsajwani]

Hi All,

I have a table with two columns Date and Balance when I visualize it as a table it is shown correctly

Report Month  MI Balance
2017-01-31      XXX
2017-02-28      XXX
2017-03-31      XXX 
2017-04-30      XXX
2017-05-31      XXX
2017-06-30      XXX

When I convert the table in line chart it doesn't show Jan 2017 and the line just goes one axis extra. As such line at Feb shows the value of jan and line at Mar shows the value of Feb and so on. As such the last point of the line shows the value of June but doesn't have any axis beneath.

When I set the axis to hierarchy and just choose month the line chart seems to be fine. Any idea on how to fix this?

Thank you for your help in advance.

Regards,

[v-huizhn-msft]

Hi @moezsajwani,

If you want to show the date and value correctly, please display date itself not in hierarchy, set the x axis in Category type(Please see the screenshot below), if you set the continuous, it will show veryday from 2017/1/31 to 2017/6/30. 



Then the data will be shown correcly as follows.

Best Regards,
Angelia

[moezsajwani]

Hi,

Thank you for your quick repsonse. I appreciate your help and sorry for the delay in responding. I was wondering if I can show the date in graph as MMMM-YY format despite my date format in table is YYYY-MM-DD. Is it possible to present different format on x-axis without changing the original table.

Secondly, If I change the the x-axis type to categorical I cannot use the forecast line. How to deal with this issue?

Appreciate your help in advance.

Regards,

Moez

[v-huizhn-msft]

Hi @moezsajwani,

It is impossible to present different format on x-axis directly, you need to create a new calculated column in the format using the formula.

NewDate = FORMAT(Table[DATE],"MMMM-YY")

Then use the [NewDate] as the x-axis level.

Yes, I cannot use the forecast line if we change the the x-axis type to categorical. Becasue the forecast future based on the continuous date. You can create idea here.

Best Regards,
Angelia

[haozhong]

Please attach the screenshots of the graph and your table (include the whole Power BI window)