Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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?
Go to Solution.
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:
View solution in original post
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!
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.