Help With Heat Map to Carpet Chart

[GhostWarrior44]

Hi All,

I've effectively been using a heat map as my carpet chart, Currently I have : Count({$<[Item Rev Status5]={'Approved' , 'NA'}>}[Item Rev Status5]) : GREEN

And , Count({$<[Item Rev Status5]={'Not Submitted', 'Rejected', 'In Review'}>}[Item Rev Status5]) : RED

Id like to be able to Count and make more than two colors......I have 5 Statuses.... "Approved, In Review, Rejected, Not Submitted and NA" .... Id like to get a diff color for each one....does anyone have any suggestions....

PS: They can only be in one status at a time.... Gradient scale wouldn't wont work....

Thanks!!!

[Lisa_P]

You could create an additional field with values 1-5 for each status and use that field (no aggregation) as the measure and apply the Diverging BuYlRd 5 values color schema

[GhostWarrior44]

Great suggestion. It works great. Thank you