Forum Discussion
Solved
Values not sorting in chart visual, but correct in table visual?
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 t...
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....
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....