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
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Anonymous,

I tried changing the order of the third table in the query editor, and it did nothing. 

Based on my test, after changing the order of the table in the query editor, we still need to reload the query/table to data mode to reflect the column order changes to Data mode.

 

To reload the data mode, you can uncheck the "Enable Load" option, then recheck the option for the query/table in query editor, then Refresh your data mode after "Close&Apply". :smileyhappy:

 

 

Regards

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
    Microsoft 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      I don't think I can reorder using DAX, because the SUMMARIZE function always puts the summarized columns first.

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Microsoft Employee
        9 years ago

        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