Forum Discussion
Conditional Formatting a matrix
- 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.
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.