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....
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
