Creating a simpler and chart-friendly Date table in Power BI
A Date table in Power BI can have a smaller number of columns by leveraging custom format strings to adequately control the chart visualization and the sort order.
A Date table usually has columns such as Month and Day of Week that should be sorted by the underlying ordinal number – rather than by using an alphabetical order on the names of the months and days. In order to do that, we create two columns for these attributes: one column with the visible name, which is sorted by another column containing a number. For example, Month is sorted by Month Number in the following DAX calculated table: