Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to change data type?

With the recent ribbon changes, I can't figure out how to change data type.  As you can see below, the date with the day is included in my visual but when I go to transform data, it's the date format I want.  How do I change it?

  • Anonymous's avatar
    Anonymous
    6 years ago

    This is a little bit confusing. But the display format is always set in the Power BI Desktop Window, not in Power Query (where you can change the data type).

     

     

    Best Regards

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    This is a little bit confusing. But the display format is always set in the Power BI Desktop Window, not in Power Query (where you can change the data type).

     

     

    Best Regards

  • If you click on the column you will see under column tool in data view

     

    In transform data/edit query. It under transform data