dynamic insights

Copilot might be able to do this. The Narrative visual can also be used but not very easy to work with. Other than that you will need to create a measure or a column or a combination of both to achieve this.  This is just a very simple example:

Project Narrative =
VAR ProjectName = [Project A]
VAR Status = [Delayed Status]
VAR MissedMilestones = [Milestones Behind]
VAR Progress = [Enrollment %]

RETURN
ProjectName & 
" (" & Status & ") - " & 
MissedMilestones & " milestone(s) behind schedule; enrolling at " & 
FORMAT(Progress, "0%") & " of plan"

powerbiexpert22 
Yes you can create this by adding calculated column & before that you must have KPI measure bases on current enrolment vs Planned Enrollments and you have to add condition in the column such as,

For an example if you want something like:

Project A – On Track – 85% enrolled vs 80% planned

Project B – Behind Schedule – 60% enrolled vs 75% planned

Project C – Milestone Reached – 100% enrolled vs 100% planned

and the number of projects changes automatically based on the data.

Project Status =

SWITCH(
    TRUE(),
    [Enrollment %] >= [Planned %], "Milestone Reached",
    [Enrollment %] >= [Planned %] * 0.9, "On Track",
    "Behind Schedule"
)

Then create a measure for the narrative:

Project Summary =
SELECTEDVALUE(Projects[Project Name])
    & " - "
    & [Project Status]
    & " - "
    & FORMAT([Enrollment %], "0%")
    & " enrolled vs "
    & FORMAT([Planned %], "0%")
    & " planned"

Add this measure to a Table Visual.

The table will itself show one row per project and expand/contract as projects status changes.

If this helps, ✓ Mark as Kudos | Help Others