Forum Discussion

netanel's avatar
netanel
Post Prodigy
6 years ago
Solved

sort index

Hello everyone! I'm trying to sort out the rows of my report. I want to open a new index column that will work according to an existing column. column B the new one, According to the data of colum...
General Comment
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi netanel ,

    Difficult to explain this error message. One simple solution is that we had better go back to create measure😑. But sort by column function is only useful to columns, so a potential solution is that put the measure in the visual and click the three dots(...) on the right corner of this visual, use sort by in the visual by the measure or description as I previous mentioned.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

netanel's avatar
netanel
Post Prodigy
6 years ago

Sorry I think I just did not explain myself correctly

I try to prepare a profit and loss statement, but the sections do not sort me out in order.

I tried to sort column A by column C in the table I made before but got the message in the picture

 

 

 

 

That's why I tried all the RANK formulas I tried to create a new and more correct order column
What am I doing wrong?

 

Thank you so much for your time!

netanel's avatar
netanel
Post Prodigy
6 years ago

Hey,

Column B My intention for a new index column
To be based on column A.
Column C is an index column that I have already built in Excel, it actually brings the number 1 to the first item in profit and loss and also to the first item in the balance sheet and other reports and this way the tab of the comment pops up.

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi netanel ,

    Seems I cannot reproduce it in my environment. Could you please consider sharting a dummy .pbix file for further discussion? Please remeber to replace the sensitive information in your file.

     

    Best Regards,

    Yingjie Li

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi netanel ,

    Please try to create a calculated column using the previous formula and use sort by column on column description based on the calculated column.

    Or try to use the sort by description in the visual directly:

     

    According to the previous error message, you can refer these simliar issues: 

    1. Sorting error - can't be more than one value 
    2. Sort by columns returns error 

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi netanel ,

    Difficult to explain this error message. One simple solution is that we had better go back to create measure😑. But sort by column function is only useful to columns, so a potential solution is that put the measure in the visual and click the three dots(...) on the right corner of this visual, use sort by in the visual by the measure or description as I previous mentioned.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • netanel's avatar
    netanel
    Post Prodigy
    6 years ago

    Hi thanks for the response,
    I think there's something else I'm missing here, this is the result I get