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

Date format in DAX Matrix

I'm trying to format date format from ex: Thursday, April 9, 2020 TO 4/9/2020 from within the Matrix view but it is still depicting the date in the matrix as Year|Qtr|Month|Day. Just to note that I went into Modeling and change Date Type:Date m/d/yyyy format and it changed the data in the fields. However, once as I switch to DAX Matrix, it is still reflecting the date format Year,Qtr,Month,Day. I've been searching how to do this but all results are pointing to change it in Modeling, which I have already done. Shouldn't the Matrix incorporate my selected date format??

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User IX
Super User IX

Re: Date format in DAX Matrix

In the fields area, click the drop down arrow and switch from hierarchy to just the date.

---------------------------------------

Not link spamming! If I posted a link in reply it is because I did assume you know how to search the web but thought it was the fastest way to fix your issue.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Super User IX
Super User IX

Re: Date format in DAX Matrix

See screen shot.

 

image.png


---------------------------------------

Not link spamming! If I posted a link in reply it is because I did assume you know how to search the web but thought it was the fastest way to fix your issue.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
Highlighted
Super User IX
Super User IX

Re: Date format in DAX Matrix

In the fields area, click the drop down arrow and switch from hierarchy to just the date.

---------------------------------------

Not link spamming! If I posted a link in reply it is because I did assume you know how to search the web but thought it was the fastest way to fix your issue.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Super User IX
Super User IX

Re: Date format in DAX Matrix

See screen shot.

 

image.png


---------------------------------------

Not link spamming! If I posted a link in reply it is because I did assume you know how to search the web but thought it was the fastest way to fix your issue.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Helper I
Helper I

Re: Date format in DAX Matrix

Greg, thank you! Right before you responded I found the solution on my own!!!! Thank you and I have accepted your solution!

Highlighted
Super User IX
Super User IX

Re: Date format in DAX Matrix

Yeah, it annoys me that it defaults to hierarchy!! I find myself having to change it more often than not!

---------------------------------------

Not link spamming! If I posted a link in reply it is because I did assume you know how to search the web but thought it was the fastest way to fix your issue.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.