Can Matrix column header get name of value selected in a switch?

[rpinxt]

Maybe a bit cryptic but maybe some picture will explain better.

So I have this matrix and a slicer:

You see the matrix has a column names LBE Selection and that works with the LBE chose in the slicer (in this case lbe2).

The LBE Selection works on a SWITCH formula :

LBE Selection =

SWITCH(

Metrics[Selected LBE],

1, [LBE1],

2, [LBE2],

3, [LBE3],

4, [LBE4],

5, [Plan]

)

All works like a charme just wondering if there is a way to make the colum header variable?

So instead of LBE Selection it would look nicer when its calles LBE2 and if I would choose LBE1,...LBE1 etc.

[v-yanjiang-msft · Accepted solution]

Hi @rpinxt ,

I'm afraid you can't do it directly, here's my workaroud.

1.Create a card visual, and create a measure like below, put the measure in the visual.

Header = SELECTEDVALUE(LBE[LBE])

2.Put the card visual on top of the LBE Selection column header, get the result.

Here're some related threads, you can see if it helps: 

Solved: Dynamic matrix visual column headers - Microsoft Power BI Community

Solved: Dynamic column header in Table or Matrix - Microsoft Power BI Community

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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

[rpinxt]

Thanks @v-yanjiang-msft 

That could be indeed be a workaround.

Say how did you add that pbix file??

That would be really helpful to add sample books if you ask help from the community.