
Contributor III
2019-07-26
09:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
New Multi KPI color change based on Measure value
Hi Team
I am Trying to give color to my multi Kpi based on my value.Means if i have negative value then it should show red colour if i have positive value it should show green value.
This is my formula for variance.i want to change the variance kpi color based on my value.In this picture variance -694 should show red color because it is having negative values.
sum({1<Country=p(Country),Type=p(Type)>}[Latest estimate])
-
sum({1<Country=p(Country),Type=p(Type)>}Budget)
Thanks
2,108 Views
2 Replies
2019-07-26
09:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Answer is "No"
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
2,103 Views

Partner - Contributor III
2022-08-19
03:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@sarithaallot @Anil_Babu_Samineni
These days it is possible:
Variance is below zero and it is red
You have to:
- add Measure (Master item) for Variance
- define Segment colors for Variance (Master item, Measure)
- select Conditional value color for Variance measure on your's Multi KPI object
Master items, Measure - Segment colors
Defined Segment colors for Variance measure
Multi KPI - Conditional value color
