Matrix Column header formatting

[Anonymous]

Hi 

I am having a requirement where I should concatenate Measure Name with another Measure Content. To be detailing, I am having Workitems, Open Date and SalesRep columns in my data. I am trying to create a matrix table where in populating Number of Open Workitems in last week (for instance 4/25/2021 to 5/1/2021) by Created by SalesRep. I was able to get the counts for last week open Workitems. But what I am trying to do is in the matrix column header I wanted to show "WorkItemsOpened Last Week 4/25/2021 to 5/1/2021" instead of actual value header. Referring to below table "Open" is the measure name  and respective values and I have another measure Measure 2 which returns "Open WorkItems for last week 4/25/2021-5/1/2021)".    So in Matrix column header I wanted to Dislay "Open WorkItems for last week 4/25/2021-5/1/2021)" instead of "Open". Appreciate for help.

Sales Rep	Open
One	20
Two	27
Three	40
Total	87

Was trying to display like below 

Sales Rep	Open WorkItems for last week 4/25/2021-5/1/2021)
One	20
Two	27
Three	40
Total	87

[Greg_Deckler]

@Anonymous Generally you would do something like that in a separate Card visual. You create a measure to concatenate things and then drop it into a Card visual. Not sure how you would pull that off as a matrix column header, especially if you want it to be dynamic.

[Anonymous]

I totally agree, where I need some help will this be feasible to do in table or matrix.

[v-lionel-msft]

Hi @Anonymous ,

Solved: How to create a dynamic measure name in Power BI? - Microsoft Power BI Community

Unfortunately, it's impossible to achieve the idea in current version.

Best regards,
Lionel Chen

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