Filtering global Reporting charts using project custom fields

I’ve been trying to build a Dashboard in the Reporting feature to report on a private Portfolio which contains several projects built using the same custom fields (single select, multiple select, numbers, text, etc); but I can’t see any of custom fields in the “Add filter” > “Custom field” dropdown unless I only report on a single project.

Doing my best to explain here:

  • Project A & B are both private projects which include a single-select in-project-created custom field called “CustomField1”.
  • Project A & B are part of the portfolio “Portfolio1”.
  • If I create a dashboard in the Reporting tool and select Include tasks from “Portfolio1”. I can only filter by Organization wide custom fields which are part of my company and not by the “CustomField1” which lives inside projects A & B (or any in-project-created custom field).
  • If I create a dashboard in the Reporting tool and select Include tasks from “Project A”. I then can filter using the custom field “CustomField1”. However, if I then include tasks from “Project B” also, the “CustomField1” information is only displayed for “Project A” in the chart.

It seems Portfolio based charts can only filter by Organization wide custom fields even if all the projects inside the portfolio have the same in-project-created custom fields. I can’t make my custom in-project fields org. wide as there are already existing org. wide filters with the same name but including different options; and naming the field “CustomField1TeamABC” is not a scalable solution for a multiple-100K employees company (plus the large name is not easy to display in List view without very wide columns).

Is there a solution or workaround to this? Is this an issue with how several projects are created by duplicating an original project vs creating new projects with the same name custom fields?