Trying to Reorder Columns in Data View in Power BI

powerbi powerbi-desktop
Ifad Noor picture Ifad Noor · Jan 24, 2019 · Viewed 8.8k times · Source

Is there a way I can reorder columns in 'Data View' within Power BI? I tried doing it in Power Query first but when the data loads into the table, the columns automatically rearrange.

Answer

Alexis Olson picture Alexis Olson · Jan 24, 2019

I don't know that you can rearrange an existing table, but if you re-create it as a new table, you can pick the order you want.

NewTable =
SELECTCOLUMNS (
    OldTable,
    "Column1", OldTable[Column1],
    "Column2", OldTable[Column2],
    "Column3", OldTable[Column3]
)

Related questions

Creating a Measure that returns DISTINCT COUNT by Country and Brand in Power BI

I have a table like below: Country, Advertiser, Brand, Spend C1, A1, B1, 10 C1, A1, B2, 5 C1, A2, B3, 0 C1, A2, B4, 20 C2, A1, B1, 8 C2, A1, B5, 7 C2, A2, B6, 4 C2, A2, B3, 3 C2, A2, B7, 2 C2, A3, B8, 9 …

Read More
Show/Hide column in Power BI Table/Matrix visual

Is there any possibility to show or hide the column in Table/Matrix visual in Power BI report by user dynamically? For Example, I have a table view with columns COLUMN-1, COLUMN-2, COLUMN-3. Now I may have filter drop down …

Read More
Subtract two Date/Time columns in Power BI

How do I subtract two Date/Time columns in Power BI. If I have: How do I find out the time difference between Last Updated and Created Time (in hours)?

Read More