Forum Discussion

power-bi-noob's avatar
power-bi-noob
Icon for Helper I rankHelper I
3 years ago
Solved

Change the way a table visualization displays date

I have a table visualization that includes a date, which currently displays as mm/dd/yyyy hh:mm:ss. I would only like it to display as mm/dd/yyyy for this particular visualization. I do not want to c...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    3 years ago

    Hello power-bi-noob ,

     

    format the date column with the datecolumn tools tab to short date.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

     

    Follow me on Linkedin

power-bi-noob's avatar
power-bi-noob
Icon for Helper I rankHelper I
3 years ago

I am looking to change this field's appearance in this visualization only, I don't want to change it in the model. If I want to make the value the color blue, I can, but if I just want to see the date without the time, that doesn't seem to be an option. You can easily do this in Excel (change the way the date displays without changing the underlying data). It's puzzling that you can't do that in Power BI.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

In that case, I have added columns via splitting the original into 2 new columns (leaving the combined original).  Then using whichever column you want/need... in your case it sounds like the date without time column.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos