Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
So i have this table going on and I want to Sort it by :
-New Car
-In Warr
-Out Warr
-Aged Car
-Fence Sitter
The Age Type Column I couldn't see in my Query Editor as this is a "New column" that I created it in Power BI desktop.
I need help. Not sure on how to go further.
Solved! Go to Solution.
Hi @Anonymous
This is a screenshot of a visual, not of a table in PQ Editor, right?
There are not many reasons to re-order columns in the PQ Editor as it does not flow through to the Designer.
If this is a visual then:
1. Create a separate ranking table with two columns: "Headers" and "Rank". The rank would reflect the order you want the headers to appear on the visual.
2. Make a relation to this table from your original table to link headers to, what I guess is, one of your measures/columns.
3. Use the headers from this new table as headers for the table visual.
4. In this new table (in Designer) select the "Header" column and in the ribbon Modelling->Sort by Coumn select "Rank" instead of "Header".
This should re-order the table visual columns to what you want.
Kind regards,
JB
Hi @Anonymous
This is a screenshot of a visual, not of a table in PQ Editor, right?
There are not many reasons to re-order columns in the PQ Editor as it does not flow through to the Designer.
If this is a visual then:
1. Create a separate ranking table with two columns: "Headers" and "Rank". The rank would reflect the order you want the headers to appear on the visual.
2. Make a relation to this table from your original table to link headers to, what I guess is, one of your measures/columns.
3. Use the headers from this new table as headers for the table visual.
4. In this new table (in Designer) select the "Header" column and in the ribbon Modelling->Sort by Coumn select "Rank" instead of "Header".
This should re-order the table visual columns to what you want.
Kind regards,
JB
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.