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.
When I load data from an SQL database via Direct Query the date formatting is ie 01/01/2016 in tables and graphs
But wnen I load the same data from the same source via Import the formatting is Year Quarter Month Day
I would like 01/01/2016 style
Trying change the formatting once loaded at the table level does not fix it.
Ideas?
Solved! Go to Solution.
Hello,
Thanks for the suggestion.
I had tried the date format previously without success but the right click on the Date in the 'Value' field and unchecking the Hierarchy did the trick.
did you try the below steps?
1. change the datetime format
2. By Default if you drag the date filed then it will display as Date Hierarchy. if you want only the date format, can you Uncheck the Hierarchy option as below
Thanks
saravanan
Hello,
Thanks for the suggestion.
I had tried the date format previously without success but the right click on the Date in the 'Value' field and unchecking the Hierarchy did the trick.
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |