Advice on creating such visuals

Hi mp390988,

Calculation Groups are the right solution for this kind of report because your Excel layout is not just showing data but applying the same calculations (like MTD, YTD, targets, variance, and percentages) across many measures, and Calculation Groups are built exactly to handle this cleanly in Power BI. While it is technically possible to recreate the report by using summarized tables or separate measures, that approach leads to duplicated logic, harder maintenance, higher risk of errors, and difficulty making future changes. Calculation Groups centralize the logic in one place, keep calculations consistent, make updates easier, and reduce the number of measures needed. The concern about support is not a technical problem but a training and documentation issue, and avoiding a good design just because it is unfamiliar will only create more problems long term. 

Thanks & Regards,

Prasanna Kumar