Multiple groupings for Column Headers

[Anonymous]

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!

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may use 'Unpivot columns' in query editor. Attached the sample file for your reference.

Regards,

Cherie

[Jveselka]

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. 

[MFelix]

You need to had a column with the sorting number and then make a sort by another column:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

[Jveselka]

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.  

[MFelix]

Hi @Jveselka,

You don't need to place the sorting column on the visual if you use the sort by other column that will work properly. 

[Jveselka]

Ok, I'll see if I can do that. Now for another question.  I'm new to DAX so here is an example of the conditional column I created to group two columns.  I need the data in those two columns to be a calculation.  How do I add that in to DAX statement or is there another way.  

= Table.AddColumn(#"Unpivoted Other Columns", "Group", each if [Attribute] = "AppsPD" then "Life Apps" else if [Attribute] = "Apps" then "Life Apps" else null)

Example - 

APPS PD = Standards[AppsPD]*[TruncPeriod]/12

Apps1 = Standards[Apps]*[TruncPeriod]/12

[MFelix]

Hi @Jveselka ,

Not sure what you want to calculate, you refer dax however you send a code with M language (power query)

What is the final result you want to achieve?

[Jveselka]

Grouped columns 1 and 2 and columns 4 and 5 need a calculation added. This is based on the period they select.  I have a column the strips off the month in the period. 202305 for the calculation

TruncPeriod = MID('Standards'[Period],5,7)

Apps1 = Standards[Apps]*[TruncPeriod]/12

So using grouped column 1.  This needs to group the two columns and do a calc for each 

Example - 

APPS PD = Standards[AppsPD]*[TruncPeriod]/12

Apps1 = Standards[Apps]*[TruncPeriod]/12

I can do this using a table visual but not sure if it will work with the matrix visual.

[MFelix]

HI @Jveselka 

This should also work for a matrix, you may need to had a group column to your model in order to have everything correctly presented on the matrix, but shous work.

[MFelix]

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

[Anonymous]

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?