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.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-field-list#field-list-changes
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 will be treated as unique. They won't be summed.
Sometimes Desktop guess correctly and other times not so much. I have text fields in a table that Power BI Desktop thinks are Identity Fields but are not.
The problems is when I place an incorrectly tagged Identity Field in a Slicer, it shows every value, not just the unique values. How do I tell Desktop to stop thinking a field is an Identity Field?
I have a Pro license. My data started in a Dataflow in Power BI Service. I then used Power Query in Desktop to bring the Dataflow in and load into my model. I then Publish my model to Power BI Service to created a Dataset.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.