Skip to main content

    Power BI

    Needs Votes

    Column sort order based on unique key as attribute to another column value to allow for multiple duplicate values in a dimension

    Vote (1) Share
    Aaron's profile image

    Aaron on 25 Jun 2020 20:22:15

    today, to sort one column based on another, all values must be unique. However, bringing in text dimensions from large databases often have unique keys, but duplicate values that are not necessarily the same. We need the ability to sort these "duplicate values" based on their unique key as we do not want to add key values to the visuals.