Hour Report, Portfolio Chart + Monthly Filter + Sort by Hours Descending

I'm building a report to track hours invested per portfolio per month and running into two issues. Would love to know if anyone has found a solution.

Issue 1 — Portfolio chart in an Hour report

I built an Hour report with filters for the current month ($$TODAYbm / $$TODAYem) and groupings by Portfolio and Project. The monthly filter works perfectly, but when I try to build a chart, Portfolio Name doesn't appear as a Y axis option (only Project Name and Owner show up.)

I switched to a Project report to get Portfolio on the chart, but then I lose the ability to filter hours by month since Actual Hours on projects are cumulative totals.

Is there a way to have both a monthly hour filter AND a Portfolio chart in the same report?

Issue 2 — Sort chart bars from most to least hours

In my chart, the bars are sorting alphabetically by Portfolio name. I want them to sort descending by hours so the portfolio consuming the most hours appears first. I've tried adding sort order in the Groupings text mode but the chart still sorts alphabetically.

Is there a way to force a value based sort on a Workfront chart?

Thanks in advance!