Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I created a date table and creating relationships with some other tables I have. All of my values are showing up corrctly, but there is a gap in my date axis. One table is counting the measures recorded from dates Jan - June, and the other table is counting measures from July - October. Does anybody know a workaround to closing this gap?
Thank you!
Hi , @Anonymous
According to your description, the dax show a gao on X-axis. Right?
For this situation, we need to avoid the following situations:
(1)Whether your date table is consecutive dates, generally our date table is created using the CALENDAR() function.
(2)This is the case if the evaluated value is BLANK for the date on which the GAO occurred. If you need to avoid it, you need to calculate the date of the returned blank value to return the value you want.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@Anonymous Try something like this: Mind the Gap (Irregular Time Series) - Microsoft Power BI Community
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
100 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |