Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

ranking visualisation

Hello,   I am using a Line and Stacked Column chart to show the ranking of a particular value and how it is positioned within a Red, Amber and Green grading.   The problem is that since I am usin...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI Anonymous ,

    Maybe you can remove sum function to directly compare column value and measure result:

    test RANK = RANKX(ProjectAuditsDB,ProjectAuditsDB[column1],[KPI Warnings_Value])

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI Anonymous ,

Maybe you can remove sum function to directly compare column value and measure result:

test RANK = RANKX(ProjectAuditsDB,ProjectAuditsDB[column1],[KPI Warnings_Value])

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Excellent!

 

Many thanks Anonymous