Bar graph not plotting correctly for single row

I am using Grafana version 6.7.3 with MySQL as my datasource.

My query is:
count(id) AS “Opened”
FROM table_name
__timeFilter(requestedDate) AND requestedApi in ("myapi") GROUP BY 1 ORDER BY __timeGroup(requestedDate,$__interval)

I am using the Graph panel to plot the results using bars. When there are multiple rows in the result, the graph plots correctly, but when there is only row, the bar graph spreads through the entire X-axis

When I select Point to represent the graph, I get a single point correctly.

How can I get a single bar correctly at the specified date instead of the bar spreading to the entire X axis? Please advise me.