Ultimate Calendar (Thank you AVI!); shows the Date as an identifier instead of a Date

[Polygon]

Cannot pull the Date field from the Ultimate calendar into visualizations when it is crossing 2-3 different tables.

1.  Ultimate Calendar Date (identifier field) linked to Date in Invoice Open Balance Table and Payments Table and Targets table

2. Using Area Chart, want to see Target on one line (based on date); Invoices on next line (based on date) and payment on next line (based on date).

Without being able to enter screenshots in this forum it is extremely difficult to explain exactly what I'm trying to get to.

Thank you.

Paula

[v-lionel-msft]

Hi @Polygon ,

Did you encounter this error when you put fields into the chart, and if so, the relationship of your data model is wrong.

Please check the relationship between your tables.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.