User Profile
RobG123
Helper I
Joined 5 years ago
User Widgets
Contributions
Re: Power BI Tip: How To Sort A Column With Duplicates By Another Column
Thanks for this. I'm getting the 'we can't sort the character column by order column error. But in my data there are no duplicated order values for values in my character column. This is a matrix count for the two columns Do you know how I could fix this? I want to sort a slicer by Grade in the order shown by numbers, not alphabeticalRe: Stop Powerbi converting date to date time and taking off 1 hour
Thanks, but this leaves times unaffacted. E.g. 07/10/2020 23:00, it converts to the same date time. In the source data in sharepoint this appears as 08/10/2020. Just to point out I have many date fields that PowerBI is making this 'auto-correction' to, so ideally I would prevent it from doing that. Rather than transofrming every column individually in PowerBI.Re: Stop Powerbi converting date to date time and taking off 1 hour
Thanks for your response. The code doesn't work because the field is already in Date Time format. PowerBI ingests as date time. I can extract the date only from the date time column, but this gives me the day before the actual date as entered in sharepoint for March to October dates.Stop Powerbi converting date to date time and taking off 1 hour
Hi, I have connected data from a sharepoint list into PowerBI. The dates in the sharepoint list are in date format, but when PowerBI ingests it converts them to date time. It also takes off 1 hour in some cases, I think this is related to daylight savings as it does this for dates from late March to end October. I think it might be trying to remove daylight saving from the dates in that period. Does anyone know how I can stop PowerBI doing this? It means that some dates are different between the list and powerBI dashboard. Thanks Rob
