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.

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

Hi netanel ,

That's right. This fomula will only work with a calculated column.

If you want to create a measure, try this formula:

Measure = 
RANKX ( ALL('Table'), CALCULATE(MAX('Table'[Column A])),, ASC, DENSE )

But it will only show a single value in the table visual because table visual will not show repeated value of one column if there is not any other field in the table visual.

 

 

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!

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

    Hi netanel ,

    In your previous post, it relates column A and B. If you want to use sort by functions based on column C and face this error message, what is the data type of these columns?

     

    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

    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