How i can show the sharepoint item's Modified Date in a single field inside my Power BI report

[fileonlineservi]

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

[fileonlineservi]

@MDoddsworked like a magic thanks a lot

[MDodds · Accepted solution]

Hi Fileonelineservi,

This happens because of the automatic hierarchy Power BI applies against date fields.

There are two easy ways to fix this:

1. Once you have added the Modified to your table, select the drop down arrow in the cisualisation pane and switch it from "Date Hierarchy" to "Modified" per the below two images.
   

   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.

   
2. The second way to avoid this is to turn off the setting that automatically applies the hierarchy in the first place.
   You can do this with 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