Forum Discussion
Helper IChange the way a table visualization displays date
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 👍
First, you can look at whichever app is used for the visualization and see if the formatting you want is available within that app.
PowerBI doesn't modify original content. It reads it in with powerquery and lets you adjust it how you want via transform within PowerBI only. In transform you can either adjust the original columns (which doesn't adjust the actual data where you're getting it from) OR if you want to play it safe you could just duplicate the column within the transform and format it the way you want in the new column, then use that differently formatted column for your visualization.
Helper II 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.
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