Forum Discussion
Advanced Card / KPI
Hi, are there any method for showing the callout value by using the distance to goal value (the percentage only) instead of the original value. Something like third image. Also, are there any method for colour coding if the distance to goal is larger than 5% , then the callout value is shown in red and less than 0% will be green. I have been using Advance card and card with states by OKVIZ also KPI but not showing out what I want. Thanks for the help.
Hi, Anonymous ;
I think you could create a measure to calculate the percent. then add card visual.
1, create a measure,
%trend = SUM([actual])/SUM([target])-12.add card visual.
3. conditional color about value.
condition = IF([%trend]>0.05,"#D64550",IF([%trend]<0,"green","black"))The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi, Anonymous ;
I think you could create a measure to calculate the percent. then add card visual.
1, create a measure,
%trend = SUM([actual])/SUM([target])-12.add card visual.
3. conditional color about value.
condition = IF([%trend]>0.05,"#D64550",IF([%trend]<0,"green","black"))The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Switch distance to goal on then turn Target Label off
Use the conditional formatting formula button to create change colour based on rules or field value
You may need to create your own KPI Card.
I'd recommended using the Matrix Visual - Miguel Myers has some great examples, as does Bas.
If these aren't working for you, you could try SVG measures: KPI Cards with Core Matrix Visual - EXPLORATIONS IN DATA STORYTELLING WITH POWER BI (kerrykolosko.com)
Otehrwise there are other options, such as HTML Content Visual; Deneb; Charticulator; PureViz
