Sorting a funnel chart

[anabianco09]

Hi,

I am trying to sort a funnel chart based on stages. I created a stage table where I have an order for them and linked to the table I am getting the values.

WHen I try to sort using the tooltips field, it automatically shows up as sum, or count... and therefore, I can't sort by the number itself. 

Any tips?

[v-xuxinyi-msft · Accepted solution]

Hi @anabianco09 

Here is my trying:

My sample:

Merge two tables:

Expand the table to preserve the order column

Select the Category column to sort by the order column.

Result:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[anabianco09]

That worked perfectly! Thank you lots! 

[MNedix]

Elegant solution @v-xuxinyi-msft, I would have done it also with an additional table but your merging of queries works great.

[MNedix]

Can you show the ordering table? How did you link it to the main table?