How to add additional column header into matrix

[Snagalapur]

Hi All,

Kindly help to add additional column into matrix (adding one more column header tagging 3 columns)

EX:

Current design :

Thank you.

[Anonymous · Accepted solution]

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]

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]

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

[Idrissshatila]

Hello @Snagalapur ,

check this example to see what I mean
https://youtu.be/oj3wn3h9tu4?si=urbXtVlY1zzuxr17

[Snagalapur]

sorry this is not i'm intending to do this, I would like have additional column header so that instead of repeating text Q3-24 Act I would like tag as header.

[Idrissshatila]

Hello @Snagalapur ,

what you're intending to do can't be done until now in power bi without the way I referenced.

you can add it as an idea on this link https://ideas.fabric.microsoft.com/