Forum Discussion
Multiple groupings for Column Headers
Is it possible to do Multiple groupings for columns in Power BI as shown in the image below. Are there any work arounds for this scenario? Sample Excel Sheet Thanks in Advance!
Hi Anonymous
You may use 'Unpivot columns' in query editor. Attached the sample file for your reference.
Regards,
Cherie
Hi Anonymous
You may use 'Unpivot columns' in query editor. Attached the sample file for your reference.
Regards,
Cherie
I was able to get this to group but how do you move other columns around to order them like I want? It seems to just put them in however it wants.
You need to had a column with the sorting number and then make a sort by another column:
Your Rock! Thanks, now how do I get rid of the column headers for those rows? Like the word Group and Sort and the 1,2,3 etc.
