Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Error when trying to change the default sort by for a column in a Datamart

I am trying to change a columns default dort by value but getting an error message. The column is a month column in a date table. 

 

{"code":"CompatibilityViolationException","message":"The usage of <ccon>table 'Calender'</ccon> will create an invalid configuration in all potential modes."

 

 

Status: Investigating

Hi  @Kieran_Ultra_23 ,

 

This could be due to several reasons, such as:

The data type of the month column is not compatible with the sort by value option. You may need to check if the month column is formatted as text or numeric in both the Power Query Editor and the Data View. If they are different, you may need to change them to be consistent.
The date table is not marked as a date table in Power BI. You may need to go to the Modeling tab and select Mark as Date Table from the menu. Then, choose the date column that represents the unique and contiguous dates for the table.
The date table is not connected to any other tables that contain date values in your model. You may need to create a relationship between the date table and other tables that use dates, such as sales orders or transactions. You can do this by dragging and dropping the date column from one table to another in the Relationships View.

 

Best regards.
Community Support Team_Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi  @Kieran_Ultra_23 ,

 

This could be due to several reasons, such as:

The data type of the month column is not compatible with the sort by value option. You may need to check if the month column is formatted as text or numeric in both the Power Query Editor and the Data View. If they are different, you may need to change them to be consistent.
The date table is not marked as a date table in Power BI. You may need to go to the Modeling tab and select Mark as Date Table from the menu. Then, choose the date column that represents the unique and contiguous dates for the table.
The date table is not connected to any other tables that contain date values in your model. You may need to create a relationship between the date table and other tables that use dates, such as sales orders or transactions. You can do this by dragging and dropping the date column from one table to another in the Relationships View.

 

Best regards.
Community Support Team_Caitlyn