Forum Discussion
KPI Arrows - Up/Down Arrows
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 HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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
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"
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 LearnBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly