Diferent cell formating for each row

Questions & Answers
1

Hi,
I would like to specify a diferente cell formating for each row, is possible

image
image1123Ă—533 21.3 KB

In the capture you can see that I have specify a cell formatig for the first row (_Highest / nueva) and is aplied for all (nueva) rows

Thanks

2

Hi @aelexpuru,
You can use conditional cell formatting to apply different colors to your measure.
Here is an example from the demo account: Risk chart by status and priority - Issues - Jira Demo - eazyBI

The formula applied for the measure “Issues created” is (change the dimension names to the one you use in your report):

-- color by priority and status 
CASE [Status].CurrentHierarchyMember.Name 
WHEN "Done" THEN "Green"
WHEN "To Do" THEN
  CASE WHEN
  [Priority].CurrentMember.Name MATCHES "Highest|High" 
  THEN "Red"
  ELSE "Yellow"
  END
WHEN "In Progress" THEN
  CASE WHEN
  [Priority].CurrentMember.Name MATCHES "Highest|High|Medium" 
  THEN "Red"
  ELSE "Yellow"
  END
END

In the report you can switch the dimensions position and at the end it can look like this:

eazyBI_report
eazyBI_report1820Ă—1322 217 KB

Kind regards,
Gerda // support@eazyBI.com

1 Like