Forum Discussion

msimmonsmcse's avatar
msimmonsmcse
Helper I
4 years ago
Solved

Conditional Formatting a matrix

I have a matrix viz that shows revenue per year, one year for each column, with customers listed in each row. I applied a conditional format (or so I thought) to each cell based on the revenue number...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi msimmonsmcse 

     

    Here is another workaround. When your data table is like below (if not, you can summarize company, year and revenue to get a table like below), 

     

    You can create a Rank column to rank revenues in different years among every company. 

    Rank = 
RANKX (
    FILTER ( 'Table', 'Table'[Company] = EARLIER ( 'Table'[Company] ) ),
    [Revenue],
    ,
    ASC,
    DENSE
)

     

    Add another color column based on rank values. You can also create a similar measure for conditional formatting. 

    Color = SWITCH([Rank],1,"#ABEBC6",2,"#F9E79F",3,"#FAD7A0",4,"#EDBB99")

     

    Format the background color based on Field value > Color column. 

     

    Hope this helps. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.