Displaying Programme / Project relationship in a PowerBI Matrix

Hi JWizard9891 ,
Thank you for reaching out to us on Microsoft Fabric Community Forum!

Upon my understanding,I tried to recreate it on my local with the sample data.So that,I followed below steps which might help you to resolve your query.

•  Create a calculated column to generate hierarchy-friendly name using below:
    

  DisplayName =
  
  IF (
  
  'Table'[Type] = "Programme",
  
  'Table'[Name],
  
  REPT(" ", 1) & 'Table'[Name]
  
  )

• Create a Parent-Child calculated column using below:
  

  DisplayName =
  
  IF (
  
  'Table'[Type] = "Programme",
  
  'Table'[Name],
  
  REPT(" ", 1) & 'Table'[Name]
  
  )

•  Create a hierarchy or sorting logic using below:
  

  SortOrder =
  
  IF (
  
  ISBLANK('Table'[ProgLink]),
  
  0,
  
  1
  
  )

•  Now,Build the Matrix visual by adding below values into the fileds:

• Rows: Function  and DisplayName

• Columns: Stage

• Values: Count of ID

• Please refer the screenshot and file for your reference:
  

  
  
  If my answer meets your requirements,consider accepting it as solution.
  
  Regards,
  Pallavi G.