How to re-arrange column in Power BI table visual

[Meraj]

I have created a simple report in table visual in Power BI Desktop to see the RAG status, which is coming from one single Excel column.

By default, Power BI takes an AGR sequence, and I wanted to make it a RAG status sequence. Please refer to the attached report (as hilighted in yellow) and let me know how I can rearrange the column in the RAG status sequence.

[audreygerred · Accepted solution]

Hello! Create a sorting column and then you can sort one column by another. In this case, RAG are text so will sort alphabetically. If you create a numeric field with R being 1, A being 2 and G being 3 you can have the text column with R, A, G sort by the numeric column. Sort one column by another column in Power BI - Power BI | Microsoft Learn