Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Adjusting Date Displayed in Visual

I have created visuals and a table based on SP lists. The table is displaying a date column. The formatting is not desired. 

 

Is there a way to change the formatting of the date field so that it displays ONLY the date? The column in SP is already formatted as 'Date Only'.

 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

    Please select the field "Date of CQ" and navigate to "Column tools" ribbon, then set the date format as "03/14/2001 (mm/dd/yyyy)" just as below screenshot.

    Best Regards

10 Replies

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hello Anonymous ,

     

    If 'First DteofCQ' is a date field you can use the following DAX formula in a column:

    Column = FORMAT(Table[First DteofCQ],"DD/MM/YYYY")

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I'm just learning Power BI. Can you please clarify where and how such an adjust is made in visual/app?

       

      Thank you!

      • themistoklis's avatar
        themistoklis
        Icon for Community Champion rankCommunity Champion
        5 years ago

        sorry, i didnt quite get your question.

         

        what are you trying to achieve?