This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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.
Solved! Go to 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
Proud to be a Super User! | |
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
Proud to be a Super User! | |
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 33 | |
| 25 | |
| 23 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 64 | |
| 41 | |
| 27 | |
| 22 | |
| 22 |