Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have this matrix
I want to order the rows in prospect,qualify,develop,solution,proof,close,won. While, the month in its usal order jan,feb .. etc.
Also, if I want to filter for
Solved! Go to Solution.
You need to create a simple dimention table : StageDim
There you assign the order for each of your stages let's say this:
Stage | Stage_Order
Prospect | 1
Qualify | 2
Proof | 3
Solution | 4
....
Then you assign "Sort by column" as I have explained.
Then you connect it to your fact table.
So when you use your column "Stage" (from the SatgeDim table) in your reports - they will be sorted by the StageOrder
Same goes for Months
Michael
Step 1: Go to Data View (on your left)
Step 2: Choose the table (on your right). In your case it should be a StageDim table that contains columns 'Stage' and 'StageOrder'
Step 3: Choose the column you want to sort ('Stage' in your case)
Step 4: Click "Sort by column"
Step 5: Choose the column you want to sort BY (in your case - 'StageOrder')
Michael
Hi @Anonymous
Its not a column , they are values inside one column. For example, column1.stage. So when I put it as rows in my matrix visualization i want to order them to my choice. Thanks
You need to create a simple dimention table : StageDim
There you assign the order for each of your stages let's say this:
Stage | Stage_Order
Prospect | 1
Qualify | 2
Proof | 3
Solution | 4
....
Then you assign "Sort by column" as I have explained.
Then you connect it to your fact table.
So when you use your column "Stage" (from the SatgeDim table) in your reports - they will be sorted by the StageOrder
Same goes for Months
Michael
This solution helped my case. Thank you!
I am using a radar chart which has Axis start position at North, I have ordered by rows using a merged table but the order on the radar chart is not correct, it is neither in the required order or starting at North??
You need have rownumber and columnnumber column to use to sort your rows and columns. I have tested it on my local environment, please refer to the screenshots below.
Regards,
Charlie Liao
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
82 | |
65 | |
63 | |
57 |
User | Count |
---|---|
171 | |
113 | |
110 | |
73 | |
73 |