cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mecho Regular Visitor
Regular Visitor

How to reformat date from mmmm/dddd/yyyy to ##/##/##

Hi,

 

I have a large matrix visual with several columns of dates. However, I quickly run out of horizontal real estate, and would like to condense the date columns down from a "Monday, July 15, 2019" format down to a "7/15/19", which takes up half of the space to show in the matrix. How can I achieve this?

pbi date too wide.PNGThis date format is too wide and clunky; I would like to show "6/12/18" for example instead of "Tuesday, June 12, 2018"

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to reformat date from mmmm/dddd/yyyy to ##/##/##

You have to select the column in the table on the right then format it.

datetimeformat.jpg

4 REPLIES 4
Super User
Super User

Re: How to reformat date from mmmm/dddd/yyyy to ##/##/##

If you select your date column in the table list on the right you can set the formatting under the modeling tab.

datetimeformat.jpg

mecho Regular Visitor
Regular Visitor

Re: How to reformat date from mmmm/dddd/yyyy to ##/##/##

@jdbuchanan71  thank you for your speedy reply!

 

When I select the column in my table, it resorts it, but the Formatting tab under Modeling remains greyed out. Am I selecting the column the right way, by clicking on the header?

pbi dates not working.PNGI selected column 'Issue Date', but the 'Formatting' tab remains greyed out, as seen above.

 

I have double-checked to make sure that the column was formatted as "Date" in Querty Editor.

pbi issue date is date.PNGColumn "Issue Date" is formatted as date

Super User
Super User

Re: How to reformat date from mmmm/dddd/yyyy to ##/##/##

You have to select the column in the table on the right then format it.

datetimeformat.jpg

mecho Regular Visitor
Regular Visitor

Re: How to reformat date from mmmm/dddd/yyyy to ##/##/##

@jdbuchanan71thank you!

pbi dates fixed.PNGExactly the way I wanted it

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 296 members 3,145 guests
Please welcome our newest community members: