Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Kieran_Ultra_23

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

Submitted by on ‎09-21-2023 05:07 AM

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

See more ideas labeled with:
1 Comment (1 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
‎09-21-2023 06:16 PM
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

Idea Statuses