Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Merhaba
Bir pareto grafik yaptım ve %80 olarak renklendirme yaptım.Şimdi yapılan şey örnek veriyorum %80 denk gelen (Top2) sırala yapıp bir grafikte hemen 1. yada tek 2. olarak önlemeye.yardım edin.
Solved! Go to Solution.
Hi @verianalist2022 ,
It seems that you want to re-arrange the order based on the standard=0.8 in visuals. For example:
measure value | expect rank |
0.87 | 3 |
0.9 | 2 |
0.92 | 1 |
0.76 |
6 |
0.54 | 5 |
0.23 | 4 |
If so, please try:
Rank =
var _1=RANKX(FILTER(ALL('Table'),[Measure]>=0.8),[Measure],,DESC,Dense)
return IF([Measure]<0.8, RANKX( FILTER(ALL('Table'),[Measure]<0.8),[Measure],,ASC,Dense)+_1, _1)
And apply it to Tooltips pane, and sort the axis by it:
If not, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @verianalist2022 ,
It seems that you want to re-arrange the order based on the standard=0.8 in visuals. For example:
measure value | expect rank |
0.87 | 3 |
0.9 | 2 |
0.92 | 1 |
0.76 |
6 |
0.54 | 5 |
0.23 | 4 |
If so, please try:
Rank =
var _1=RANKX(FILTER(ALL('Table'),[Measure]>=0.8),[Measure],,DESC,Dense)
return IF([Measure]<0.8, RANKX( FILTER(ALL('Table'),[Measure]<0.8),[Measure],,ASC,Dense)+_1, _1)
And apply it to Tooltips pane, and sort the axis by it:
If not, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.