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

date format in table visualization (how to keep as is and not get sub-date formats)

I am trying to use a date format variable and create a view of a date... When I click on date visualization instead of getting a date i get 4 sub-variables (i.e., year, quarter, month, day). I just want the table view to show the date variable as is (e.g., 9/17/2017). I do I change the format to do that? ~Bryon

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Hi @Bbrown44

 

You simply have to click on your column name so it will display dates instead of trying to create hierarchy

 

hierarchie.PNG

 

-Quentin

View solution in original post

Highlighted

@Bbrown44

 

you can found the formatting option right here : 

 

changedate.png

 

Have a good day

 

- Quentin

View solution in original post

3 REPLIES 3
Highlighted
Solution Sage
Solution Sage

Hi @Bbrown44

 

You simply have to click on your column name so it will display dates instead of trying to create hierarchy

 

hierarchie.PNG

 

-Quentin

View solution in original post

Highlighted

Great!!! This does work however the format of the date is now (e.g., Friday, December 01, 2017)... How do I keep the original formatting (i.e., 12/01/2017).

 

Thanks for your help!!!

Highlighted

@Bbrown44

 

you can found the formatting option right here : 

 

changedate.png

 

Have a good day

 

- Quentin

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors