cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Post Patron

## Switch Axis: 10 turns into a 1

Hey Guys,

simple case. I have a ranking. The higher the number, the better. Suppose I

Value 1 = 7 >> should turn into the number 1

Value 2 = 5 >> should turn into the number 3

Another issue is, the numbers can be decimals. The max is unknown, hence the 7 can be a 10 as well. The numbers must be used as a y axis in a line chart.

I am not sure if this can be solved via measure, perhaps with a column?

1 ACCEPTED SOLUTION
Community Support

Hi @raymond

I’m not quite sure about the requirements, figure that you’d like to generate the rank, the higher of the value, the better ranking.

And then use the ranking as Y-axis, the values as the X-axis.

Thus I created the sample with columns [Values] and add the measure:

`Rank = RANKX(ALL(Table1),CALCULATE(MAX(Table1[Values])))`

Result shown as below:

Best regards,

Dina Ye

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
2 REPLIES 2
Community Support

Hi @raymond ,

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

Best regards,

Dina Ye

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

Hi @raymond

I’m not quite sure about the requirements, figure that you’d like to generate the rank, the higher of the value, the better ranking.

And then use the ranking as Y-axis, the values as the X-axis.

Thus I created the sample with columns [Values] and add the measure:

`Rank = RANKX(ALL(Table1),CALCULATE(MAX(Table1[Values])))`

Result shown as below:

Best regards,

Dina Ye

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

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors