Forum Discussion

AFinster's avatar
AFinster
Helper I
6 years ago

Need Help! KPI Visual (Indicator / Trend / Target) issue

Greetings all, (Sorry if this is a bit long winded ...) I am attempting to build a (hopefully!) basic KPI Visual. It is based on a snapshot of a number of companies in our group, and shows Week Num...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi AFinster ,

 

Is below what you need?

If so,you only need a measure as below:

 

 

Previous Week Total Workforce = 
IF(ISFILTERED('Table'[Staff type]),CALCULATE(SUM('Table'[Total Staff]),FILTER(ALL('Table'),'Table'[Week No.]=MAX('Table'[Week No.])-1&&'Table'[Staff type]=MAX('Table'[Staff type]))),CALCULATE(SUM('Table'[Total Staff]),FILTER(ALL('Table'),'Table'[Week No.]=MAX('Table'[Week No.])-1)))

 

 

#3 In the fields ,you should set as below:

Here is a reference about KPI which may help.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

 

For the related .pbix file,pls click here.

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!