Looking for a New Years resolution to boost your morale and increase your market value? Join us at Power BI Dev Cap and learn how to get started designing and implementing custom visuals for Power BI. Campers will learn how to define custom visual capabilities and data mappings as well as how to program D3-style data binding using categorical data from a Power BI dataset. The session also demonstrates other essential skills including how to extend a visual with custom properties and how to package a custom visual as a PBIVIZ file.

How to keep your users sweet by adding help to Power BI reports in three easy steps.  

We may face the following situation when importing data to Power BI:

From the data source, the whole column is in the right date format. Once being imported into Power BI, the column will have dates in two formats as below:

Mon 16/11/20 throws an error.

3/15/2021 indicates the correct format.

Through this blog, I will show you how to use Power Query and DAX to convert different date types into unified format.