Changing time to a day before on x axis graph

I am trying to show a graph for users logged in per day and per month.
so what i am doing is querying number of yesterday’s and previous month number logged in users.
but on graph yesterday’s data would show on today’s timeline(eg- suppose if its tuesday and i query logged in users data for yesterday it would show on tuesday’s timeline in x axis in graph. i want to show today’s queried data on yesterday timeline in graph).
So is there a way i can change the x axis on grafana to a day before. I hope i was clear :sweat_smile:.

if i query data once a day on day end it shows a very thin line on graph so i thought above approach could be used. Any suggestions for implying this is welcome.

datasource- prometheus