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,

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.pbix?dl=0

 

Regards,

Daniel He