Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
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.
Unfortunately, thats the only solution i have
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/
Proud to be a Super User!
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |