Forum Discussion

mossharry15's avatar
mossharry15
New Member
2 years ago
Solved

KPI Arrows - Up/Down Arrows

Hi all,  I have the below dashboard created with a month filter just out of shot.  What I'd like is within each card visual to have a green up arrow/red down arrow dependant on the result of last m...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi mossharry15 ,
    Based on your description, you want to display up or down arrows on the KPI. In my tested version 2.130.930.0 64-bit (June 2024), the default legend is tick. If you want to use arrows.
    First, you need to turn off the icon and Trend axis options under KPI.

    Then create a judgmentmeasure to use the arrow icon like this.

    Arrow = 
IF (
    [Calculate A] = [Calculate B],
    "",
    IF ( [Calculate A] < [Calculate B], UNICHAR ( 11015 ), UNICHAR ( 11014 ) )
)

    Finally you can assign colors to the arrows based on your judgments

    Arrow color = IF([Calculate A]<[Calculate B],"Red","Green")

    You need to combine KPIs with cards. First, put the Arrow measure in the card and turn off the Category lable option

    Then fx apply the Arrow color measure in the Callout Value option.

    Final output

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi mossharry15 ,
Based on your description, you want to display up or down arrows on the KPI. In my tested version 2.130.930.0 64-bit (June 2024), the default legend is tick. If you want to use arrows.
First, you need to turn off the icon and Trend axis options under KPI.

Then create a judgmentmeasure to use the arrow icon like this.

Arrow = 
IF (
    [Calculate A] = [Calculate B],
    "",
    IF ( [Calculate A] < [Calculate B], UNICHAR ( 11015 ), UNICHAR ( 11014 ) )
)

Finally you can assign colors to the arrows based on your judgments

Arrow color = IF([Calculate A]<[Calculate B],"Red","Green")

You need to combine KPIs with cards. First, put the Arrow measure in the card and turn off the Category lable option

Then fx apply the Arrow color measure in the Callout Value option.

Final output

 

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

 

mossharry15's avatar
mossharry15
New Member
2 years ago

Thank you very much. It has made things clearer already. 

As I said in my previous, I'm brand new to Power BI so apologies for the next question. My data is formatted as per the below (with other months below), what would i be putting where you've said "Calculated A" and "Calculated B"