mse1's avatar
mse1
New Member
6 years ago
Status:
Needs Votes

Group measures in Matrix

Matrix is a perfect way to compare lots of measures. But the visual apperance could you a grouping feature. Let's assume you needs to show item sales with (item number in rows) Sales, GM, GM% Sales LY, vs. LY This requeres 6 measures. but if you need to show this in 3 "categories" (today/mtd/ytd) you need 18 measures. which is not a problem. but for people to know the difference, you will need each measure in the matrix to be called forexample sales Today, sales month to date, sales ytd etc. if you were able to create measure "groups", were that "group" was nameable. the group could be called Today. then all underluying measures could just be called Sales. Then create another measure group called month to date etc. So it's a grouping function on columns(and on rows) within the visual. not on the datatables it self. since you can't always build hierarchies on the things you want "visually grouped". like this https://ibb.co/YBSY6CH Ps. maybe also a option to upload pictures to ideas on this forum to better understand idea.

Recent ideas