Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day everyone,
I am using funnel chart to represent a set of data value.
I will love to sort the data in asending order... I tried sorting but to no avail
see attached for clarity
Do the following.
Go to "Sorting"
1) Put your dimension on the top of the list
2) Change the sorting from auto to custom
3) Check the box on "Sort By Expression"
4) click on "Fx" and in this window, copy the formula of your measure. Then click ok.
5) Uncheck all other sorting types.
6) Sort this by "Ascending".
Do the following.
Go to "Sorting"
1) Put your dimension on the top of the list
2) Change the sorting from auto to custom
3) Check the box on "Sort By Expression"
4) click on "Fx" and in this window, copy the formula of your measure. Then click ok.
5) Uncheck all other sorting types.
6) Sort this by "Ascending".