Forum Discussion

JJ015823's avatar
JJ015823
New Member
3 years ago

KPI ARROW INDICATORS

Hello,

 

I'm new to building dashboards with PBI.  My group has been completing a weekly status report using pivots tables and powerpoint to share with Sr. Leadership. I've recently set up a dashboard in PBI to show the same data, with the exception of KPI indicators showing the increase or decrease from the previous week.  

 

We're using Alteryx to combine multiple data sheets into one masterlist that is loaded into PBI. For reporting purposes, our weeks run from Friday - Thursday and Alteryx creates the "submission week", ie. 05/12-05/18.  This is the used in the slicer to update all tables and graphs.

 

I found a KPI formula to show the changes by year, but I don't understand how to do this by my "submission week".  I'm trying to create a messure that will give me current week request and prior week request.  The measures I found are:

 

Profits CY = CALCULATE([Total Profits],FILTER(Data,Data[Year]=MAX(Data[Year])))

Profits PY = CALCULATE([Total Profits],FILTER(Data,Data[Year]=MAX(Data[Year])-1))

 

Anyone have any suggestion? 

 

Thanks!

No RepliesBe the first to reply