Forum Discussion
Does table column position matter??
Hi Anonymous ,
You can refer to the similar case, from the discussion of our engineers and designers, we know this behavior is by design. About the order of the fields matter, the documentation has an article explaining why the result is different depending on the order, see: https://docs.microsoft.com/en-us/power-bi/desktop-show-items-no-data .
Based on my test, changing the order of the columns , removing and re-adding fields will change the results . To work around the issue, you need to display all fields of the same table next to each other.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-xicai
Wow, thank you for the provided article and other case.
I had similar "problems" with another report, i couldnt explain why exported data was different than the totals in the pbi report.
So do i understand it correctly, when all fields would be in the same table there wouldnt be an issue.
How would you suggest to join the tables? Edit query and then join every table until its all in one?
Thanks
Community SupportHi Anonymous ,
>>To work around the issue, you need to display all fields of the same table next to each other.
The words above mean that you might display the fields which from the same table in order next to each other. For example, the displaying column order can be TableA[A1] , TableA[A2] and TableB[B], but not in order TableA[A1] , TableB[B] and TableA[A2] .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.