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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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