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.
Hey,
Is it possible to change the time format value from "hh:mm:ss" to "hh:mm AM/PM" (24 hours) in Power Query?
Thanks, Ido
Solved! Go to Solution.
You can just choose that format for that column once the table is loaded on the Column Tools tab.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @buser1 ,
Ok found a way to do this in Power Query, by selecting your column and selecting Format - Trim. If you are on the Add Column tab it will place it in a new column. If you are on the Transform Tab, it will change the column that you selected. However it changes it to Text. Then if that will work for you for whatever additional transformations, you need to do in Power Query great! If however you bring it down to Power BI and need to change it back into Time, you can select that format. Please see below:
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
You can just choose that format for that column once the table is loaded on the Column Tools tab.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @buser1 ,
In PQ try this. You may have to convert the column to text.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi, thanks for the response.
I actually need to convert from this specific format:"hh:mm:ss" to "hh:mm AM/PM" (24 hours and without seconds)
Is there a way to do this in PQ or is the only right way to do it in the model?
Hi @buser1 ,
Ok found a way to do this in Power Query, by selecting your column and selecting Format - Trim. If you are on the Add Column tab it will place it in a new column. If you are on the Transform Tab, it will change the column that you selected. However it changes it to Text. Then if that will work for you for whatever additional transformations, you need to do in Power Query great! If however you bring it down to Power BI and need to change it back into Time, you can select that format. Please see below:
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Nice. You can also use:
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 |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |