Forum Discussion

MarkShu's avatar
MarkShu
Icon for Helper I rankHelper I
8 years ago
Solved

How sort zero-values like the biggest values?

How sort zero like the biggest value in matrix? I need show 1 to 100, but 0 should have shown on the bottom like bad(red) values, not on the top like good (green) values. Also I should not hide zero-...
Need Help
  • MarkShu's avatar
    MarkShu
    8 years ago

    Hi! Eventually I just did 0 like null and formatted blank in red. 

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi MarkShu

could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

 

Regards,

Daniel He

  • MarkShu's avatar
    MarkShu
    Icon for Helper I rankHelper I
    8 years ago

    Hi! Eventually I just did 0 like null and formatted blank in red.