Area Chart

[Dodzik]

Hello,

We are moving our report data source from Power BI (PRO) to Tabular Model. Each element of the model was moved to the Tabular by copying the code from Power BI. After recreating the reports, we are experiencing issues with Area Chart.

On the first screenshot, you can see the chart on the right and data (same measure/attribute combination). Matrix on the right is here just to show you what data is beneath. Area chart used here is scaled, so on small portion of the screen user sees three years of data month by month with trend line drawn in middle.

After moving metadata to the Tabular model, Area Chart looks completely different - data is not displayed in 'compact' view, there's a scrollbar on X axis that's not supposed to be there.

So, summing this up, I am using same columns and measures in both reports, data types, relationships and any other properties (i.e. ShortDate as type of date) are the same. Visuals are copied from one to another file, all settings of the visual are the same, yet it looks different.

One thing I noted is that in the version working correctly, in visual options, under X Axis, Type it's showing Continuous and Scale Type = Linear, whereas in Tabular Model it's automatically set to type Categorical, with no Scale type and no way to set it to Continuous.

[lkalawski]

Hi @Dodzik

Does your Date field come from the Date table which is marked as 'Date table'?

_______________
If I helped, please accept the solution and give kudos! 😀

[Dodzik]

I tried setting Calendar table both as date and non date table. None of those worked.