Forum Discussion
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. ...
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.
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.
Hello Ashish_Mathur
That was the problem.
The data type was text, so I changed it and voilà!
How ever, I have another glitch. The order of the months is wrong.
Any advice?
Thank you again,
You are welcome. In the Calendar table, sort the Month name column by the Month number column. To te visual, drag Month name from the Calendar Table. Just search for YouTube videos on sorting months in PowerBI