Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
NJ81858
Helper IV
Helper IV

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.

NJ81858_0-1694526506875.png

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!

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.