Multi row card dynamic data formatting

[dokat]

Hi,

I have multi row card that diesplays 4 measures. All in percentages. Is it possible to individually format these values based on criteria.

For Ex: If WT CAGR is greater than 0% highlight in green if not in red.

I used below formula to format however it formats all the measures based on the result first measure (GP CAGR <0)

Color = SWITCH(TRUE(),

[GP CAGR]<0,"Red",

[NS CAGR]<0,"Red",

[OIS CAGR]<0,"Red",

[WT CAGR]<0,"Red","Green")

Appreciate anyone who can help!

[RKM]

Although this might not be what you want to hear... But I'd probably not put them in Multi card and rather break them individually and format accordingly. Then place them side by side such a way that it appears like a multi card. You need some square box etc. for additional formatting like a combined header etc.

[dokat]

Unfortunately, thats the only solution i have

[ValtteriN]

Hi,

I am somewhat sure what you are trying to achieve is not possible. The format measure in multirow card is evaluated in the filter context and in your example it notices always that [GP CAGR]<0,"Red" is true -> because of this the end result is always red. Instead of multirow card you could look into custom visuals or format a table visual to match your desired end result.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/