Slicer Sort Issue

Hi Greggyb

 Please do not apologize for anything you are doing grate in helping people online and i know how hard and time consuming it is becasue i was doing this on the SSIS forum, anyways thank you and thank you to the Microsoft team putting these forum out to help people.

I am self learnning Power Bi myself and trying to make some real world examples and getting myself ready for the future of the PowerBi and Microsoft new technologies and trying to be a futur contributer at this forum like you in the future like as i did for SSIS .

Anyways i did what you asked to be more exact i am trying to doa a PriceBanding like

  [Price]     [Price Bracket]

     1               Under 1000

     2               Under 1000

     .

     .

  1000           [1000 - 2000]

  1001           [1000 - 2000]

you get the idea, so what i do is

1- click on the [Price Bracket] field

2- Click on the "sort by Column" ribon on top

3- select the [Price] field

and i get an error of .....

We Cannot sort the [Price Bracket] column by [Price] field. you can not have more than one value in the [Price] field for the same value in [Price Bracket]. choose a different column for sorting or update the data in Price$

.......

the strage thing is that it is saying the the Price$ field is not unique if you check the M code it is

the M code is like

let
    Source = {1 .. 100000 },
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Price"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Price", Int64.Type}}),
    #"Price Bracket" = Table.AddColumn(#"Changed Type", "PriceBand1", each 
if   -1 > [Price] then "Unknown"
  else if     0 <= [Price] and [Price] <  1000 then "Under 1000"
  else if  1000 <= [Price] and [Price] <  2000 then "[01  -2  K]"
  else if  2000 <= [Price] and [Price] <  2500 then "[02  -2.5K]"
  else if  2500 <= [Price] and [Price] <  3000 then "[02.5-3  K]"
  else if  3000 <= [Price] and [Price] <  3500 then "[03  -3.5K]"
  else if  3500 <= [Price] and [Price] <  4000 then "[03.5-4  K]"
  else if  4000 <= [Price] and [Price] <  4500 then "[04  -4.5K]"
  else if  4500 <= [Price] and [Price] <  5000 then "[04.5-5  K]"
  else if  5000 <= [Price] and [Price] <  5500 then "[05  -5.5K]"
  else if  5500 <= [Price] and [Price] <  6000 then "[05.5-6  K]"
  else if  6000 <= [Price] and [Price] <  6500 then "[06  -6.5K]"
  else if  6500 <= [Price] and [Price] <  7000 then "[06.5-7  K]"
  else if  7000 <= [Price] and [Price] <  7500 then "[07  -7.5K]"
                else if  7500 <= [Price] and [Price] <  8000 then "[07.5-8  K]"
  else if  8000 <= [Price] and [Price] <  8500 then "[08  -8.5K]"
                else if  8500 <= [Price] and [Price] <  9000 then "[08.5-9  K]"
  else if  9000 <= [Price] and [Price] <  9500 then "[09  -9.5K]"
                else if  9500 <= [Price] and [Price] < 10000 then "[09.5-10 K]"

  else if 10000 <= [Price] and [Price] < 11000 then "[10-11K]"
                else if 11000 <= [Price] and [Price] < 12000 then "[11-12K]"
  else if 12000 <= [Price] and [Price] < 13000 then "[12-13K]"
                else if 13000 <= [Price] and [Price] < 14000 then "[13-14K]"
  else if 14000 <= [Price] and [Price] < 15000 then "[14-15K]"
                else if 15000 <= [Price] and [Price] < 16000 then "[15-16K]"
  else if 16000 <= [Price] and [Price] < 17000 then "[16-17K]"
                else if 17000 <= [Price] and [Price] < 18000 then "[17-18K]"
  else if 18000 <= [Price] and [Price] < 19000 then "[18-19K]"
                else if 19000 <= [Price] and [Price] < 20000 then "[19-20K]"

  else if 20000 <= [Price] and [Price] < 25000 then "[20-25K]"
  else if 25000 <= [Price] and [Price] < 30000 then "[25-30K]"
  else if 30000 <= [Price] and [Price] < 35000 then "[30-35K]"
  else if 35000 <= [Price] and [Price] < 40000 then "[35-40K]"
  else if 40000 <= [Price] and [Price] < 45000 then "[40-45K]"
  else if 45000 <= [Price] and [Price] < 50000 then "[45-50K]"

  else if 50000 <= [Price] and [Price] < 60000 then "[50-60K]"
  else if 60000 <= [Price] and [Price] < 70000 then "[60-70K]"
  else "[70K +")
in
    #"Price Bracket"