Rename Hierarchy level in Matrix visual

[WojnarBSF]

Hello,

I have a simple matrix and I would like to rename one of the date hierarchy levels: QTR 1 to Q1, etc. Is it possible?

[amitchandak · Accepted solution]

@WojnarBSF , You can not rename. You have to create you own custom date table and columns(and Hierarchy), of needed

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[amitchandak · Accepted solution]

@WojnarBSF , You can not rename. You have to create you own custom date table and columns(and Hierarchy), of needed

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[WojnarBSF · Accepted solution]

Thank you very much for this advice. I've just created a custom date table that fulfills my requirements.

DAX:

Date = ADDCOLUMNS (
CALENDAR (DATE(2019,1,1), DATE(2025,12,31)),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"Qtr", "Q"&QUARTER([Date]))