Forum Discussion
cn4422
1 year agoHelper V
Matrix - conditional formatting single row
Hello, I have a matrix table with several columns. I only want to format a single column (or maybe two). I have two values, "count (=Anzahl) and "%" - and I only want to format the "%" of a sing...
- 1 year ago
hi cn4422
How do you identify a single country column? What makes one a single country? Or do you mean only Deutschland is to be formatted? If so, create the measures that return the values just for that specific country and apply the conditional formatting to those measures. Example:
Anzahl - Deutschland = CALCULATE ( [Anzahl], KEEPFILTERS ( 'table'[Country] = "Deutschland" ) )
danextian
1 year agoSuper User
You mean to format based on the max value of each column? You can rank row categories within that column. Example.
Rank per Geo =
RANKX ( ALL ( Geo ), [Total Revenue],, DESC, DENSE )