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

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'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?