Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Union column order

I'm trying to use the UNION function with two summarized tables and a third table.   The first two tables are summarized in the exact same way, and their resulting column order is also the same. Th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

 

 

 

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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