Forum Discussion

Snagalapur's avatar
Snagalapur
Helper IV
1 year ago
Solved

How to add additional column header into matrix

Hi All,   Kindly help to add additional column into matrix (adding one more column header tagging 3 columns)   EX: Current design :   Thank you.  
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Snagalapur ,

    I create a simple table as you mentioned.

    Then I think you can create a calculated column.

     

    Group = 
IF(
    'Table'[Kind] IN {"Revenue", "AR", "DSO"} && 'Table'[Value]<=3,
    "Q3-24 ACT",
    "Q3-24 LE3"
)

     

    So you can add these columns to matrix visual.

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Idrissshatila's avatar
Idrissshatila
Super User
1 year ago

Hello Snagalapur ,

 

this header you're referencing should be added as a column in the column section of the matrix and it will show the measure per each value in the column.

  • Snagalapur's avatar
    Snagalapur
    Helper IV
    1 year ago

    Thank you for taking time on this, could you please share example it will really helpful

    currently i do not have addtional column for header EX Q3-24 ACT, Q3-24 LE3. should i create parameter ? could you please help