Rename one column in Matrix

[salexa]

Hi,

I'm creating a matrix, with columns from Date calendar(year month, with filter the current month +11months) and a measure as Values,counting IDs by a date column which is linked to the Date calendar but there are IDs that don't vave values for this date column and I the matrix I need to shown them in a separate column  that should be named "Nodata".

is tehre a possiblity to rename this column in the matrix, as the example below, the underlined column with yellow to be named NoData:

Thank you!

[Anonymous · Accepted solution]

Hi @salexa ,

According to your statement, I know you add a column from Date calendar table in matrix column field. Now you want to rename blank header to NoData. Blank is the value in Date[column]. We couldn't rename it as column header directly. I suggest you to create a calculated column in Date calendar table to replace blank value by NoData.

Replace Blank = 
IF ('Date'[column] = BLANK(),"NoData",'Date'[column])

Best Regards,
Rico Zhou

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

[Greg_Deckler]

@salexa You could potentially use a custom matrix hierarchy: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...