Forum Discussion
Calculation group not displaying in order
I'm playing around with the new calculation group functionality in the Oct 2023 release of BI Desktop. I ordered the calculation items in the order desired for reports:
However, when used in a report, the order reverts to alphabetic.
Any ideas how to get the report to be in the order set in the model view?
Thanks!
2 Replies
- Ritaf1983
Super User
Hi Stacey_Griffeth
I haven't tried it yet, but I guess that the logic is the same as on calculated groups that are created with a tabular editor.
So you can try this guide :
https://www.youtube.com/watch?v=mLWRfKIgYvkIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Ritaf1983 thank you for that link, that was definitely something I did not know! Unfortunately, it is not quite the same as the issue I'm facing. That video shows us how to set which column to sort by within the calculation group. The issue I'm having is with the order of the columns within the calculation group. I've followed Microsoft's guide on creating the groups and setting the order of the columns within the group via the model view. But when applying the calculation group to a matrix, the order I set is not reflected and, instead, it is in alphabetic order. That might be fine for some uses, but when they are all time intelligence, I want it to be something like MTD, QTD, YTD, PY MTD, PY QTD, PY YTD... instead it's coming out MTD, PY MTD, PY QTD, PY YTD, QTD, YTD. I'm thinking it's some sort of bug.
