Forum Discussion
Union column order
Reloding the data as you suggested did change the column position in the data view, however it is still in the wrong order after the UNION
Hi Anonymous,
Reloding the data as you suggested did change the column position in the data view, however it is still in the wrong order after the UNION
According to your description above, I have tested it on my environment with the latest version of Power BI Desktop(2.48.4792.721 64-bit (July 2017)). And the UNION works all fine the the right order after reordered the column in Query Editor.
Could you share a sample pbix file which can reproduce this issue? So that we can help further investigate on it. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
In addition, I just wondering if it is possible for you to reorder the columns for the summarize table by modifying it's DAX formula. :smileyhappy:
Regards
I don't think I can reorder using DAX, because the SUMMARIZE function always puts the summarized columns first.
Hi Anonymous,
So could you share a sample pbix file(with just some sample/mock data) which can reproduce this issue? So that we can help further investigate on it. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:
Regards
I am sorry for the long delay. I had needed to re-work my data, and the tables were unioning properly. However, when I had need to change it again, I am getting the same issue again.
Here is a pbix file in which I replicated the problem (TableF)
https://drive.google.com/open?id=0B_6Tqj6N3i6HZnR6TG5qQ2lmLWM