Forum Discussion
Stuck on Continuous Date implementation
I've successfully created a handful of line charts which plot a metric over time, using a separate Date Table to supply the x-axis. However, today when trying to build a forth, it's just not working and I can't figure out why.
In the screenshots below you can see how I setup the Portal Stand-Up Dates. I copy/pasted this viz and replaced the Y-axis with a new metric, but it does not register the dates like in the other. Both of these are connected via relationships to the Date Table on their corresponding date fields. The other two branches off the Date Table in the relationships screen shots are to other ables for different over-time metrics I want to do display, which are also working as expected.
What am I forgetting in this instance?
Thanks for the replies from Kaviraj11.
Hi jam17 ,
Based on your description, I reproduced your question in the picture below:
The problem may be due to the fact that the accounting_time field is not in the date range of the datetable. If you use a field from the datetable table when creating a visualization object that does not contain all the dates from the accounting_time field, this may cause the display to be blank. Ensure that the datetable's date range covers all dates in the accounting_time to avoid this problem.
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
What's the datatype and format on Accounting_Time column?
Accounting_time is Date and Long Date format, which is the same as the "Created Date" in the Portal Standup.
Can you share some example with pbix file or screenshot to troubleshoot error?
Thanks for the replies from Kaviraj11.
Hi jam17 ,
Based on your description, I reproduced your question in the picture below:
The problem may be due to the fact that the accounting_time field is not in the date range of the datetable. If you use a field from the datetable table when creating a visualization object that does not contain all the dates from the accounting_time field, this may cause the display to be blank. Ensure that the datetable's date range covers all dates in the accounting_time to avoid this problem.
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
