Forum Discussion
Rename Hierarchy level in Matrix visual
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?
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.
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]))
2 Replies
- amitchandak
Super User
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.
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]))