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

     

     

     

foodd's avatar
foodd
Community Champion
2 years ago

Hello mossharry15 , and thank you for sharing a question with the Community.   This reply is informational. Please follow the decorum of the Community Forum when asking a question.

Please share your work-in-progress Power BI Desktop file (with sensitive information removed) and any source files in Excel format that fully address your issue or question in a usable format (not as a screenshot). You can upload these files to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then provide the file's URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!