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

[gavexe]

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:

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

But now if we have wide time period:

While using dates gives us much more affordable option:

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

[devesh_gupta]

@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]

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)