Skip to main content

    Power BI

    Needs Votes

    Sorting error "There can't be more than one value in'ColumnB' for the same value in'ColumnA'."

    Vote (1) Share
    Y W's profile image

    Y W on 16 Dec 2020 07:52:50

    When sorting ColumnA using ColumnB as a key, the following error occurs if there are multiple value of ColumnB for CommunA.

    There can't be more than one value in 'ColumnB' for the same value in 'ColumnA'.

    It is generally possible that there are multiple values, so please improve to avoid this error.

    https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column#sort-using-the-sort-by-column-button