Grouping SSRS results by cell background color

I have created a report in SSRS which shows Disk information on multiple servers, and it is set so that background cells turn orange if free space is under 20% and red if under 10%. I would like to have the RED cells (critical disks needing cleaning) at the top of the report.

Is there a group expression I can make to achieve this (grouping by back ground color or % < 10)? I couldn’t figure it out.
No questions on this online either from what I have seen

  • MySQL vs Microsoft SQL
  • Is it possible to use a Case statement in a sql From clause
  • Can an indexed view be made to handle this user rating scenario?
  • When to use with clause in sql
  • Does running a SQL Server 2005 database in compatibility level 80 have a negative impact on performance?
  • Conversion failed when converting the varchar value 'my returned value' to data type int
  • Thanks!

    One Solution collect form web for “Grouping SSRS results by cell background color”

    You can simply order by the percentage of free disk space ascending.

    Putting this as an answer as I genuinely think this is it!

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.