More flexible columns in matrix table

Hi Anonymous ,

take a look at this solution.

https://community.powerbi.com/t5/Desktop/How-do-I-add-average-min-and-max-columns-to-matrix/m-p/1180179

In the end I managed the view I want, with the function "unpivot column" The only problem is after the table change from pic a to pic b, for the report, I need to drag newly updated month into "Values" field of visual manually every month.

Hope in the future there could be option,to group unpivoted columns into one group, so no more need to worry about update.