How sort zero-values like the biggest values?

[MarkShu]

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-values and replace them something like "999999".

[v-danhe-msft]

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 · Accepted solution]

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

[v-danhe-msft]

Hi @MarkShu,

Based on my test, you can refer to below steps by using the “Color by rules” function:

1.I have entered some sample data to test for your problem like the picture below:

2.Create a Matrix visual and add the related fields, use the “Color by rules” function and set the format like the picture below.

Now you can see the result.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/8gnowohqh7cncg6/How%20sort%20zero-values%20like%20the%20biggest%20values.p...

Regards,

Daniel He