Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
In my excel file I have columns formatted only with time hh:mm:ss.
When I upload the file to power Bi it adds a random date.
Is there any way to make power BI just pick the time or take the values of the excel file as it is.
Thanks
Solved! Go to Solution.
Yes! You just need to go to Power Query (Transform Data) or the Table view in Power BI and change that column type to "Time" only. It is defaulting to Date/Time which is unnecessarily adding that date. The screenshot I have attached is from the Table view.
Hi! In Power Query, you can choose the Time format instead of Date/Time or you can split the date and time, format the time as time and delete the date column since you don't need it.
Proud to be a Super User! | |
Yes! You just need to go to Power Query (Transform Data) or the Table view in Power BI and change that column type to "Time" only. It is defaulting to Date/Time which is unnecessarily adding that date. The screenshot I have attached is from the Table view.
One question that it just came to my mind. If I update the table with a new excel file, will I need to set up the format again in the table?
Thnak you! I'm still new to power BI and didn't it was this easy.
User | Count |
---|---|
77 | |
76 | |
45 | |
31 | |
27 |
User | Count |
---|---|
98 | |
89 | |
52 | |
48 | |
46 |