How to Text format in colum contain multiple value

Questions & Answers
1

Hello Team,
I have below measure for pulling all linked issue, which result multiple linked isues with status.
– annotations.group = 4 Issue links and hierarchies
Case
When
[Bugs linked to Stories].Currentmember is [Bugs linked to Stories].Defaultmember
Then
Generate(
– get a list of linked issues
[Issue].[Issue].GetMembersByKeys(
[Issue].CurrentHierarchyMember.get(‘Bugs linked to Stories’)
),
– show by key
“[“||
cast([Issue].CurrentHierarchyMember.Key as string)
||”](https://Xyx/browse/”||cast([Issue].CurrentHierarchyMember.Key as string)||“)”
|| " - " ||
– show issue status
[Status].[Status].GetMembernameByKey(
[Issue].CurrentHierarchyMember.Get(“Status ID”)),
chr(10))
END

All I want Done text to be in Green colour and Ready to dev in Blue. I tried cell formatting based on Done value but this formate whole cell. I just want only done and ready to dev text in different colour

image
image937×358 20.4 KB

@gerda.grantina @zane.baranovska @martins.vanags @roberts.cacus

2

Hi @Deepak

You are almost there! You may want to add CASE WHEN condition in the part of the code where you display the issue status to color words as you need, using Markdown formatting.

So, from the comment -- show issue status to the end of the calculation, the code would be the following:

<... THE FIRST PART OF YOUR CALCULATION>
-- show issue status
case 
 [Status].[Status].GetMembernameByKey(
 [Issue].CurrentHierarchyMember.Get("Status ID"))
when "Done" then
  "<span style='color:green'>Done</span>"
when "Ready to dev" then
  "<span style='color:blue'>Ready to dev</span>"
else
 [Status].[Status].GetMembernameByKey(
 [Issue].CurrentHierarchyMember.Get("Status ID"))
end ||
chr(10))
END

:exclamation: Two notes:
Check if the status name “Ready to dev” is written correctly (case sensitive).
Remember to use formatting for the measure Text > Markdown.

Best,
Ilze, support@eaybi.com

3

Thank you so much @ilze.leite

2 Likes