Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Conditional Formatting based on row

Good Afternoon Everyone   I have a table that consists of count of number   I also applied conditional formatting based on said count of number. I want the gradation of conditional format...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

     

    Ranking within category : =
    VAR _currentcategory =
    MAX ( Categories[Category] )
    VAR _newtable =
    FILTER ( ALL ( Data ), Data[Category] = _currentcategory )
    RETURN
    RANKX ( _newtable, [Value total :],, DESC )
     
     
     
     
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

 

Ranking within category : =
VAR _currentcategory =
MAX ( Categories[Category] )
VAR _newtable =
FILTER ( ALL ( Data ), Data[Category] = _currentcategory )
RETURN
RANKX ( _newtable, [Value total :],, DESC )