Prism Release 2

In the Analytical Section, when using the Auto Tool, the Year field is automatically assigned the data type Int16, which is incorrect. The Year field should ideally be recognized as a Date data type.

Due to this incorrect data type assignment, the Visualization Canvas interprets the Year field as a numeric value instead of a date. As a result, chart representation becomes inaccurate or improperly formatted.

When the same dataset is used in Power BI, the Year field is correctly recognized as a Date type, and the visualization is rendered properly on the chart.

This inconsistency leads to incorrect chart behavior in Prism compared to Power BI.

Actual Result

Auto Tool assigns Int16 data type to the Year field.

Visualization treats Year as a numeric value.

Chart representation is incorrect or not formatted as a time-based axis.

Expected Result

Auto Tool should automatically detect and assign Date data type to the Year field.

Visualization should treat the Year field as a date/time dimension.

Chart representation should match correct time-based formatting similar to Power BI behavior.