Forum Discussion

dokat's avatar
dokat
Post Prodigy
4 years ago

Multi row card dynamic data formatting

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!
Need Help

3 Replies

  • RKM's avatar
    RKM
    Helper IV
    4 years ago

    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's avatar
      dokat
      Post Prodigy
      4 years ago

      Unfortunately, thats the only solution i have

  • ValtteriN's avatar
    ValtteriN
    Community Champion
    4 years ago

    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/