dynamically change the name of a label in a column.

[Anonymous]

Here's teh pbix file https://1drv.ms/u/s!Amd7BXzYs7AVlm0j7IBWB7EZWKIM?e=LTrZMe

I use field parameter 

Slice by = {
    ("Brand", NAMEOF('Product'[Brand]), 0),
    ("Category", NAMEOF('Product'[Category]), 1),
    ("Color", NAMEOF('Product'[Color]), 2),
    ("Continent", NAMEOF('Customer'[Continent]), 3),
    ("Country", NAMEOF('Customer'[Country]), 4)
}

I add a slicer Month-year 

I'd like when I select for the slicer monthyear for example feb 2020, I'd like that in the matrix Brand and category will be renamed as Brand feb 2020 and category feb 2020, is there a way to do it please?

[TotunG]

Not sure how to do it, would need like a concatenate function for a column header but not sure thats possible(?). Really basic idea but maybe could have a callout card above them to highlight the fact it is Feb 2020 for example?

[sturlaws · Accepted solution]

Hi, @Anonymous, 

doable, but not pretty:

First you need to create a table with all the possible combinations of header values. Then add these header values on the column of your matrix. This table should not have relationships to any other tables.

Then create a measure something like this:

Sales = var _month = CALCULATE(SELECTEDVALUE('Table'[Month]))
var _header = CALCULATE(SELECTEDVALUE(Headers[Header]))
var _sales = CALCULATE(SUM('Table'[Sales]),FILTER('Table',CONTAINSSTRING(_header,'Table'[Brand]) && CONTAINSSTRING(_header,_month)))
return
_sales

I tried to get the file from the link you provided, but there were some logins I was not quite comfortable with providing.

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.