Forum Discussion

NJ81858's avatar
NJ81858
Icon for Helper IV rankHelper IV
3 years ago

Power KPI Matrix 3.1.1 Sparkline

Hello,

 

I am trying to build out a Power KPI Matrix to show trends over time, but the Sparklines aren't quite showing what I want. Whenever a day switches, it changes the color of the Sparkline to the change from the previous day to the next day, when I want it to just show the change from the first day to the most recent day.

The Percent change metric is correct in looking from the first date to the last date, so I am not sure how I would do that. 

 

My measure to create the percent change is: 

Percent Change = 

VAR _MostRecentDay = CALCULATE(SUM('Table'[Balance]), FILTER(ALLEXCEPT('Table', 'Table'[Category]), [Date] = MAX('Table'[Date])))
VAR _FirstDay = CALCULATE(SUM('Table'[Balance]), FILTER(ALLEXCEPT('Table', 'Table'[Category]), [Date Rank] = 1))

RETURN 
DIVIDE( (_MostRecentDay - _FirstDay ), _FirstDay )

 

I also want to note that I have a Rank column for my Date, so that the earliest Date value has a rank of 1. Thank you in advance!

No RepliesBe the first to reply