Scorecard Metrics PowerBI Service

Hi NaziaK , you can follow either of the steps to get the KPI 

1. Convert Date to a Numeric KPI

Create a measure that converts a date into a number.

Example: “Days Since Last Update”

Days Since Last Activity =
DATEDIFF(
    MAX('Table'[Date]),
    TODAY(),
    DAY
)

Use this as:

KPI value

Thresholds (e.g., > 7 days = Red)

2. Use Date as Context, Not KPIUse Date as Context, Not KPI

You can:

Keep the date in the report

Link the Scorecard metric to a report page

Display the date visually in a card or table

Scorecard → Metric → Linked report

⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together!🚀  [Explore More]