Sort Funnel/Pyramid chart on “Axis” categorie in stead of “Value” output

592 views
0
<span lang="en">I have created a Funnel with categories A-Z (Axis). the value per category is expressed in euros (Value).

the funnel is now sorted by the output value, but I would like to sort the funnel from Z to A (Axis).

How can I set this?</span><img src="https://community.xviz.com/wp-content/uploads/anspress-temp/03060de377f69391cd7027570bb4a3e647cfa77d_152.PNG" />
Answered question
0

Hi sscot019,

Make sure the ‘Sort’ column data type is set to ‘Number’ and not as ‘Text’.

Regards,

Dharanip

Answered question
0

Hello Giel,

  1. You could add a new column as ‘Sort’ in your data set

2. Assign it to the ‘Sort by’ field in the power BI

3. Now, you will be able to visualize the chart based on your sorting

4. Additionally, under chart options, you can sort by ascending or descending based on the assigned field.

Please consider this as a workaround, xViz team is working on to provide a more efficient way to do this from the upcoming releases.

Posted new comment

So I used a text select to extract the number I wanted for a sort value, but when I add my “Sort” column, it is making it a count field instead of just the value, so this workaround is not working for me. What am I doing wrong?