Forum Discussion

RAHULBANDI's avatar
RAHULBANDI
Helper II
3 years ago
Solved

***Create Double headers Matrix***

Hi Team,

I'm looking to create Double Headers in Power bi Matrix, 

data:

Sale DateType of SaleCustomer NameSale AmountUnits Purchased
1-Jan-22OnlineCustomer19258153
1-Jan-22OnlineCustomer222933173
1-Jan-22OnlineCustomer3310909120
1-Jan-22OnlineCustomer373247155
1-Jan-22OnlineCustomer671747197
1-Jan-22OnlineCustomer676217159
1-Jan-22OnlineCustomer681435102
1-Jan-22OfflineCustomer684967135
1-Jan-22OnlineCustomer83500184
2-Jan-22OfflineCustomer135657113
2-Jan-22OnlineCustomer355180113
2-Jan-22OnlineCustomer515614167
2-Jan-22OnlineCustomer532379155
2-Jan-22OfflineCustomer692294122
2-Jan-22OnlineCustomer698405149
2-Jan-22OfflineCustomer694520102
2-Jan-22OfflineCustomer6917307147
2-Jan-22OnlineCustomer69920170
2-Jan-22OfflineCustomer692909177

 

Expected Output: 

 

 

Need Help
Show and Tell
  • lbendlin's avatar
    lbendlin
    3 years ago

    This can be done but it needs lots of extra work and compromises (for example you lose the formatting). it would be much simpler if you changed the column order.

     

    See attached for the implementation via crossjoin.

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    This can be done but it needs lots of extra work and compromises (for example you lose the formatting). it would be much simpler if you changed the column order.

     

    See attached for the implementation via crossjoin.

    • RAHULBANDI's avatar
      RAHULBANDI
      Helper II
      3 years ago

      Hi

      Thq for your response 

      I ahve used complex approach

      I have applied same dax, whic you have given

      but im receiving the expected output

      could you please specify is there any additional changes i need to make in visualization pane

       

       

       

       

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        You need to apply the crossjoin as well. Have you done that?