Values not sorting in chart visual, but correct in table visual?

[awg201]

Hello, i have a small yet frustrating issue where my categories are not sorted even through i have set it to sort by column by an index.

I seems like it should be simple, but it just won't seem to work...

Here is the table... [CaseMonthAgeCohort] has the Sort by column to use the [Sort] column. Sort coumn is data type: Whole number.

When it is in a table visual, the category is sorted fine. But in any other visual, it is all out of order...

Even specifying the sort by the [AgeCategory] still does not appear correct

Am I missing something?

[awg201 · Accepted solution]

Found the issue by luck....

I noticed the column had this little icon next to it

Apprently it is to mark it as an "ID Field". Which according to their documentation:

Identity field: Fields with this icon are unique fields, set to show all values, even if they have duplicates. For example, your data might have records for two different people named 'Robin Smith', and each is treated as unique. They aren't summed.

What is didn't explain is the implications and effect it has on the model....

This is set by editing the key column int he data model view:

In this case, I just cleared it, and BAM fixed....