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.

Anonymous's avatar
Anonymous
Not applicable
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.