Sort Processes
How to sort processes?
Processes are sorted by Process Id. Order can be customized with Power BI's "Order by columm"-setting.
Let's consider these three processes as example. Process Id in this case is string and it's sorted alphabetically as default.
| Process Id | Process Sort | Event Id | Next Event Id | Event Label |
|---|---|---|---|---|
| b01 | 1 | 10 | 20 | Event A |
| b01 | 1 | 20 | 30 | Event B |
| b01 | 1 | 30 | Event C | |
| b02 | 2 | 10 | 30 | Event A |
| b02 | 2 | 20 | 30 | Event B |
| b02 | 2 | 30 | Event C | |
| a01 | 3 | 10 | 30 | Event A |
| a01 | 3 | 20 | 30 | Event B |
| a01 | 3 | 30 | Event C |
In process chart a01 is the first one even if in data it's last.
To fix this,
- Select the Process Id column.
- Select Column tools -> Sort by column, and choose column to be used in sorting.
Now processes are sorted in different order.
Note
Power BI's Sort by column might be tricky to use in some cases. Power BI requires that values in column that is sorted and in column that is used in sorting matches each other (columns need to be at the same level of granularity).
See more from Sort one column by another column in Power BI - Power BI | Microsoft Learn