Forum Discussion

cn4422's avatar
cn4422
Helper V
1 year ago
Solved

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...
Need Help
  • danextian's avatar
    danextian
    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's avatar
danextian
Super User
1 year ago

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 )

 

cn4422's avatar
cn4422
Helper V
1 year ago
danextian wrote:

You mean to format based on the max value of each column?

Yes, that's exactly what I meant!

 

So you suggest to include a ranking for each column and then use the ranking as a reference for the formatting?

 

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Yup. Or you can use percentages instead

    DIVIDE ( [total revenue], CALCULATE ( [total revenue], ALL ( geo[geo] ) ) )

     

    With rank, you'll get just the number of distinct values to based formatting on. With percentage, the gradient will be based on the min and max percentage value across the whole matrix.