Forum Discussion
Advice on creating such visuals
Hi everyone,
So today i got scrutinised and told off at work because I made use of calculation groups in my report.
I spent my whole weekend learning calculation groups and applying it to my work and the following users parry2k , kushanNa , amitchandak helped me tremendously I can't thank them enough.
My team are not familair with calculation groups and their point was how will they support the reports when I am on holiday.
I never had the need to use calculation groups but I was tasked with migrating an excel report into power bi and some of the tables in the excel report were like below where you can see there are more than 1 level in the column header section (i.e. multi-tier column headers).
I was very disappointed and upset for being criticised for work that I invested a lot of my weekend time in trying to learn Calculation Groups to tackle the above visuals.
I was told these visuals can be created without the need for calculation groups or measures by just creating a summarised tables with one column containing the names of the fields. I am not sure how this works and still don't know how it will be possible to create such visuals without using Calculation Groups.
Now I have to do a presentation at work to rationalise why we should employ Calculation Groups and fight my case for taking the approach I have for this report.
Keen to hear from the wider community of their thoughts on this as I would like to know.
Any comments appreciated it.
Thank You!
- Anonymous9 months ago
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
5 Replies
- adudani
Memorable Member
Hi mp390988 ,
Take a look at the reference below. Does this help you achieve the goal? I think modifying the column header context might support your needs.
1. Use Measures as Columns in Power BI? YES, It’s Possible! 😲
- AnonymousNot applicable
Hi mp390988,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to adudani for prompt and helpful response.
Just following up to see if the Response provided by community member were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar - AnonymousNot applicable
Hi mp390988,
Just following up to see if the Response provided by community member were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar - AnonymousNot applicable
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
- AnonymousNot applicable
Hi @mp390988,
Just following up to see if the Response provided by community member were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar