Weekly KPI report in PBI

[Angie_01]

Dear, 

I'm preaparing KPI report for our team, and I want to check weekly status like to pic shows below, choose the week in textbox, and it will update the weekly data automatically. 

thanks so much for your help. 

[V-pazhen-msft · Accepted solution]

@Angie_01 

Hard to say without any data, but the easier way is to create a weeknumber column based on your date column.

Weeknumber = Weeknumber(Table[Date],2)

Then you can just use put the kpi fields in the maxtrix visual with the weeknumber column instead the weekname in the image.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Looks good. What is your question?

[Angie_01]

Hi IIbendlin, 

thanks for your response. 

This report is created by others, and I want to create similar one, however, I don't know how to do that, could you help on this? 

Angie