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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
gavexe
Frequent Visitor

How to get rid of Time part of Date/Time in DirectQuery

Hi colleagues! I have to build a Stacked Column Chart with Date on X-axis. As far as DirectQuery doesn't fully support Time Intelligence I got such situation:

gavexe_0-1694588071982.png

I transform data column to text format and got what I need:

gavexe_1-1694588134396.png

But now if we have wide time period:

gavexe_2-1694588258816.png

While using dates gives us much more affordable option:

gavexe_3-1694588336972.png

How to get last picture without apearing time on thin time periods?

2 REPLIES 2
devesh_gupta
Impactful Individual
Impactful Individual

@gavexe Make sure that the data type used is date or datetime and use axis type as continuous in the visual. Moreover you can follow this video: https://youtu.be/9DBL8znoils?feature=shared

mlsx4
Memorable Member
Memorable Member

Hi @gavexe 

 

Have you tried to create a calendar table as DimTable and then relate it to your table? (https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.