Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
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.
That worked perfectly! Thank you lots!
Elegant solution @v-xuxinyi-msft, I would have done it also with an additional table but your merging of queries works great.
Can you show the ordering table? How did you link it to the main table?
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |