I have searched all over for an answer to this, including Microsoft's Power BI documentation, but I have not been able to find a solution. I did find a Microsoft document that said "funnel charts can be sorted", but then it did not go on to explain HOW to do that!
My funnel chart is sorting by default from the item with the highest count on top to the item with the lowest count on bottom. That is to be expected from a funnel chart, but we want to sort our chart in a specific order that has to do with the chronology of landing a new customer.
Here is how Power BI sorts our data by default:
Power BI funnel chart in the default sorted order:
However, this puts the items out of chronological order, so we want it sorted as follows to represent the life cycle of a customer from initial lead to a signed contract:
Power BI funnel chart the way we'd like to sort it:
I tried adding numbers in front of our category names to override the sorting (e.g. 1.Prospect, 2.Qualified Lead, 3.Contract Sent, 4.Signed Customer), but that did not work.
Is there a way to manually order the items in a funnel chart? Many thanks for any assistance!
