Forum Discussion
Matrix with Date Repeating
Suggesting you to if possible, then share your data or create a Year , and month column from date in dax or power query. Then combine for yearmonth column and just place it in column section. I hope it will not repeat. Delete the old visual and create a new matrix visual.
Hope this helps!!-
In the Fields pane, click on the dropdown arrow next to your date column and choose New Column. You will create a new calculated column with the required date format.
-
In the formula bar, use the following DAX expression:
DAX FormattedDate = FORMAT([YourDateColumn], "MMM yy")- Replace [YourDateColumn] with the actual name of your date column.
- "MMM yy" is the format for displaying the month in abbreviated form (like Nov, Dec) and the year in two digits (like 23 for 2023).
-
Press Enter to create the new formatted date column.
-
Super UserHi Anonymous
I think you are looking column header as like as the given image.
Just place date hirarchy or simply year and month column in column section and drill down to last steps. And you will get your desired result.
Hope this helps!!
If this solved your problem, please accept it as a solution!!
Best Regards,
Shahariar Hafiz
Thank you I worked that out is there a way to show Nov 23 Dec 23 rather than two rows?
- zenisekd
-
In the Fields pane, click on the dropdown arrow next to your date column and choose New Column. You will create a new calculated column with the required date format.
-
In the formula bar, use the following DAX expression:
DAX FormattedDate = FORMAT([YourDateColumn], "MMM yy")- Replace [YourDateColumn] with the actual name of your date column.
- "MMM yy" is the format for displaying the month in abbreviated form (like Nov, Dec) and the year in two digits (like 23 for 2023).
-
Press Enter to create the new formatted date column.
-