Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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".
Solved! Go to Solution.
Hi! Eventually I just did 0 like null and formatted blank in red.
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
Hi! Eventually I just did 0 like null and formatted blank in red.
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.
Regards,
Daniel He
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 35 | |
| 34 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 136 | |
| 102 | |
| 68 | |
| 66 | |
| 58 |