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.
I have this SharePoint fields which i am showing inside Table:-
all fields are showing well, except for the Modified >> where it will be shown into 4 seperates columns inside the table (Year,quarter,Month & Day) without the time, can this be joint into a single field (showing the date & time) which i can sort and filter based on it? similar how the Modified date is shown inside sharepoint list view? Thanks
Solved! Go to Solution.
Hi Fileonelineservi,
This happens because of the automatic hierarchy Power BI applies against date fields.
There are two easy ways to fix this:
This changes it off hierarchy view. If you still don't like the date format, you can select the modified date field in your table and then go to the format pane and change the format per the below.
Go to File --> Options and Settings --> Options --> Current File -> Data Load
and turn off 'Auto Date/Time' (under Time Intelligence)
Good luck and let me know if you need further assistance.
Cheers
Hi Fileonelineservi,
This happens because of the automatic hierarchy Power BI applies against date fields.
There are two easy ways to fix this:
This changes it off hierarchy view. If you still don't like the date format, you can select the modified date field in your table and then go to the format pane and change the format per the below.
Go to File --> Options and Settings --> Options --> Current File -> Data Load
and turn off 'Auto Date/Time' (under Time Intelligence)
Good luck and let me know if you need further assistance.
Cheers
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |