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

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

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

    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'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
        Icon for Super User rankSuper 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.