Forum Discussion
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.
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.
6 Replies
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.
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
Hello Snagalapur ,
check this example to see what I mean
https://youtu.be/oj3wn3h9tu4?si=urbXtVlY1zzuxr17
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.
