Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
meiyl
Employee
Employee

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

Captures.PNG

 

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...?

 

1 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.

 

 

Capture2.PNG

View solution in original post

3 REPLIES 3
v-haibl-msft
Employee
Employee

@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

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



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

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.

 

 

Capture2.PNG

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.