Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
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! 😀
I tried setting Calendar table both as date and non date table. None of those worked.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |