Forum Discussion

PBINewbie920's avatar
PBINewbie920
Helper I
4 years ago
Solved

create header for columns in matrix?

Hi!  I currenly have a data set with many columns I created with DAX (so i am unable to unpivot them)   my columns currently look like this (in a matrix): 2021 Orders 2022 Orders 2021 Revenu...
  • TheoC's avatar
    4 years ago

    Hi PBINewbie920 

     

    In your Matrix table, under the Columns field add Orders and Revenue first, then underneath that addd the Years.

     

    If you're data model is structured appropriately, the above should work. If not, please let us know and we can further assist.


    Theo ๐Ÿ™‚