Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Matrix with Date Repeating

Hello I have a matrix very simple with dates across the top and text list down the side each one with a date  My date headers are repeating across the top I would like to have it by months and year...
Need Help
  • shafiz_p's avatar
    shafiz_p
    2 years ago

    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!!

  • zenisekd's avatar
    zenisekd
    2 years ago

     

    • 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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Yes I agree not sure how to fix it. 

the column is just a list of dates in dd/mm/yyyy format

shafiz_p's avatar
shafiz_p
Icon for Super User rankSuper User
2 years ago

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!!