Forum Discussion

ajdm2007's avatar
ajdm2007
Helper III
1 year ago
Solved

Graph with irregular behavior

Hello everyone,    In the graph, you can see that I have two metrics: one is total tickets, and the other is resolved tickets. I have removed the interactions, as the graph is displayed by months. ...
General Comment
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    Looks like the Date only column of the tickets table has a time stamp.  In Power Query, ensure that the data type of that column is Date.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ajdm2007 ,

 

This situation may occur when a corresponding record cannot be found between one table and many table. Could you check it?

 

Best Regards,

Wearsky