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.