Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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])-1

    2.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.

KerKol's avatar
KerKol
Power Participant
4 years ago

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.

How to Power BI - YouTube

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