Forum Discussion
Aggregate sum using groupby with date filter
Hi all,
I have calulated measure and refrenced it to a created table, I also created a group column in reference table to achieve following result:-
But i do not get correct result when i put it in matrix visual.
please guide me to what I am missing here. This is my test file test.pbix
The order in the matrix visual is off because the "Groups" column is in text type. To solve this you need to add an index column to the table in Power Query and then, once loaded, select the "Groups" column in the table view and use the "Sort column by" option in the ribbon and select the Index column.
1 Reply
PaulDBrownCommunity Champion
The order in the matrix visual is off because the "Groups" column is in text type. To solve this you need to add an index column to the table in Power Query and then, once loaded, select the "Groups" column in the table view and use the "Sort column by" option in the ribbon and select the Index column.