Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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!    
Need Help
Jveselka's avatar
Jveselka
Frequent Visitor
2 years ago

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's avatar
MFelix
Super User
2 years ago

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.