How to make powerbi show the data by date not by time?

[meiyl]

As picture above show. How to make powerbi only show Jun 05,  jun 06, jun 07, jun08?

I donot want it show jun 05,12AM ,jun 05 12PM...?

[v-haibl-msft]

@meiyl

It seems that you have resolved it by yourself. If it is working now, you can mark your reply as solution to close this thread. 🙂

Best Regards,

Herbert

[MattAllington]

When loading the data via get and load data (power query), change the date/time column to be of type date. 

[meiyl · Accepted solution]

Thanks for reply! Actualy my data is type date. I solved the problem: I choose my date colunm and then I change the showing format as picture shows.