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.
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?
@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
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)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
38 | |
31 | |
26 |
User | Count |
---|---|
97 | |
87 | |
43 | |
40 | |
35 |