Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Using Power BI Desktop to create reports and charts. What is the syntax for displaying dates in specific formats. For example, "01/25/2015" instead of "Monday, January 25, 2015". Etc. Thanks!
Solved! Go to Solution.
click on the time field in your model then you can click on Modeling in the Desktop ribbon and pick the desired date format
Is there a way to set the default date format in the desktop application?
In Power Query, I can select all the date fields at one time and apply the date format to all together.
In the Desktop application however, I can only select one column at a time, change it, (which will make the view shift all the way to the first colum), scroll over to the next column, select, change it, and repeat.
Very tedious for some of the larger datasets that are filled with date columns 🙂
@jj14x I'm not aware of the way in which you could manually update the M code, but there is most certianly a way in the Advanced Editor. Otherwise, if you are stuck to the UI, a quicker way to get all the columns at one time is to select a column and CTRL + Click any additional columns that will be changed to the same format. All of them will highlight and you can then select your format.
Thanks Eno1978. CTRL + Click works in the Power Query window, but for some reason, doesn't work in the Power BI desktop application. The latter forces me to select one column at a time.
Advanced editor would be in Power Query as well, right? I changed the date type in Power Query - that was easy enough. But when I return to Power BI, the date format there defaults to having the weekday before the actual date.
(I am new to Power Query/Power BI, so may be overlooking something obvious)
@jj14x If you are out of the Advanced Editor and working in the front end, then you have availability to expand the tables on the right hand side, and while you can't perform the CTRL+Click, you can navigate much easier selecting the columns from that area. The main data page will jump to the column you select.
Thanks! That's a good idea.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
51 | |
19 | |
12 | |
11 |