KPI card with dynamic year-week comparison in Power BI

[KdayaC111]

Hi, everyone,

I'm a beginner in Power BI and I need guidance creating a KPI card that displays the current week's CUCs and its percentage change compared to the previous week's CUCs.

My data:

Year-week	Week	CUCs
2023-50	50	451485
2023-51	51	451770
2024-1	1	451158
2014-2	2	449613

I want to see how is the increment respect to the previous week,

Desired outcome:

I want the KPI card to dynamically calculate and display the following:

• Current week's CUCs: The value for the currently selected week (e.g., 451770 for week 51)

for example when I select the week 51, the kpi card shoulb be look like  : 

• I'm using the following the format: Year-Week (e.g., 2023-50) as text because It don't change in date .
• I'm unsure how to create the DAX measure and format the KPI card to achieve the desired results.

Any assistance with creating this KPI card or pointing me towards relevant resources would be greatly appreciated!

Thank you vrey much!

[PijushRoy · Accepted solution]

Hi @KdayaC111 

Please checkout new card visual reference level
https://www.linkedin.com/pulse/new-cards-reference-labels-pbicorevisuals-v38ce/

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin