cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

Matrix with proper date column headings

i had month, year data as string, i fixed it and converted to DATE, It now appears as May 01, 2018.

 

i am using the Matrix but hate the column Header. Changing it to Month only shows month, not year. Using Date has full Date as shown.

 

Is there a way to format the Table column headers to look more like the bar chart Date formatting.  its much cleaner and spacing is better. please advise on how to get this date formatting on Table column headers, formatting thru PBI tables did not provide a custom option

 

 

pBI date order.png

 

1 ACCEPTED SOLUTION
Community Support
Community Support

Hi @ilcaa72

You could consider two ways

1.Change the format of "date" column to "mmmm yyyy".

9.png

2.  Add "date" column to "column" field of the matrix, then set it as "date hierachy", then delete "Day" and "Quarter", click on the "double arrow" which is called "at the lowest level".

8.png

 

Best Regards

Maggie

View solution in original post

1 REPLY 1
Community Support
Community Support

Hi @ilcaa72

You could consider two ways

1.Change the format of "date" column to "mmmm yyyy".

9.png

2.  Add "date" column to "column" field of the matrix, then set it as "date hierachy", then delete "Day" and "Quarter", click on the "double arrow" which is called "at the lowest level".

8.png

 

Best Regards

Maggie

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors