Reverse order of X axis in PowerKPI 2.0 visual

[Amilks]

I'm having trouble with the Power KPI 2.0 visual. I need to sort the X axis in what would be reverse order with 0 appearing on the right hand side and am not finding any way to do such.

I need this to read 50 to 0 

The KPI 2.0 visual doesn't have the option to change sort axis in the option menu 

The X axis is a simple mapping table that displays values from 0 - 150. I have changed the sort order in the Transform data tab and created a seperate column in the mapping table that is in reverse order to have the a axis values sorted in that way. Neither way keeps the sort order when it is used in the visual. 

The only reason I am using the Pro KPI 2.0 visual is to have an area with line chart as a visual. This is the solution I found searching this forum, in case there is another way to display area and line that could also solve this problem. 

Thanks!

[v-yalanwu-msft · Accepted solution]

Hi, @Amilks ;

You could Transform data then sort dec and add index.

Then select the value column and sort by index column.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Amilks]

Hello @v-yalanwu-msft 

Thank you for looking into this. I had tried to hand code a column index that could sort the column that I wanted to use as my X - Axis. I still wasn't able to control how the Power KPI 2.0 visual was sorting the axis. What I found that fixed the issue was changing the axis data type from Continuous to Categorical and then the visual was able to pick up the ordering that I had defined with the column. 

[Amilks]

Hi @amitchandak and thanks for looking into this!

I tried the DAX for Column Sort but ended up with a circular dependency. I assume that the sort column needs to reside in the same table as the axis column, but PowerBI is unhappy that I am using my axis column to generate the sort column and then using it to sort the axis. 

[amitchandak]

@Amilks , Create sort column and use that and try

Column 1 =  [Your Axis Column]

Column Sort = rankx(table, [Your Axis Column],,desc,dense)

Mark Column sort as sort column of column1 and use column1 on axis 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c