KPI Arrows - Up/Down Arrows

[mossharry15]

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

For example, within the top left if the Scheduling Margin was 42% last month, there would be a little red arrow next to the current "scheduling" margin displayed on the screenshot. 

NOTE: I'm brand spanking new to Power BI, so any clear and dummed down explinations would be really helpful. 

Thank you in advanced, 

Harry

[v-heq-msft · Accepted solution]

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]

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"

[v-heq-msft]

Hi @mossharry15 ,
Thank you for your reply, if you want to create a kpi report, you need to have a current date data and a target date data, that is, June data in the value and July data in the target, so that the July data will be used as a benchmark to measure whether the June data is on target or you can put a fixed value in the target to measure whether the data is on target or not for each month. or you can put a fixed value in target to measure whether each month's data meets the standard.

For more details you can refer to this document
Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn

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]

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

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/1447...

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!