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.
Hi,
Can anyone help me to solve this... I have a data with custom date format dd/mm/yy. But when i create visual, why it appears long format date starts with yy/mm/dd?
How can i change it to be seen as per chart below starts with dd/mm/yy?
Thanks
Solved! Go to Solution.
1. Go to query editor.
2. In your table, right click on the date column and duplicate it first so that we still have the original column untouched.
3. Right click on your duplicate column, say Date-Copy, and select Change Type -> Using Locale
4. Set Data Type as Text, Locale as English (United Kingdom).
5. Close and Apply
6. Use Date-Copy along with your calculation. In the visual, sort it in ascending order.
1. Go to query editor.
2. In your table, right click on the date column and duplicate it first so that we still have the original column untouched.
3. Right click on your duplicate column, say Date-Copy, and select Change Type -> Using Locale
4. Set Data Type as Text, Locale as English (United Kingdom).
5. Close and Apply
6. Use Date-Copy along with your calculation. In the visual, sort it in ascending order.
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |