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?
Thanks in Advance!
Hi Anonymous
You may use 'Unpivot columns' in query editor. Attached the sample file for your reference.
Regards,
Cherie
11 Replies
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:
Hi Anonymous
Believe that you are talking about making a visual with that similar look? You should use the Matrix visual and add the number of columns/rows you need to achieve the hierarchy that you want.
Regards,
MFelix
Hi MFelix
Yes, I'm trying to create a visual with similar look.
I want the Launch Date, Launch Approval columns under 'Launch' grouping and Approval Status, Testing Status columns under 'Status' grouping.
Can you please provide the steps on how to achieve this in a matrix visual?
