Forum Discussion

cuongle's avatar
cuongle
Advocate II
10 years ago
Solved

Show Date in Table

I am not sure that I understand how table represents the Date Type. I just drag and drop Expiry Time and it shows me as below, what I want is to show ExpireDate in single column with format dd/MM/yyy...
Need Help
Tips and Tricks
Tutorial Requests
  • ashishrj's avatar
    ashishrj
    10 years ago

    cuongle Follow steps as given below instead of selecting Date Hierarchy. And date format you can set it in model. Hope this helps !

     

greggyb's avatar
greggyb
Resident Rockstar
10 years ago

Power BI will default to creating a date hierarchy for you when using a date field in a visualization. You can change this in the field options when you bring in the date field. For this and other (mostly localization) reasons, I'll often use a DisplayDate field that is a string formatted exactly as I'd like my dates to be shown.

 

Here are two screens showing how to change whether the date or hierarchy is displayed: