Forum Discussion
Helper IIRename one column in Matrix
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!
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- Greg_Deckler
Community Champion
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/963588#M428
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
