cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors