Index Column & Rows

[Yrstruly2021]

I have created an index column to display my rows as below, which is correct.

When I bring in my DAX, the row in question goes to the bottom and it should not be. How can I correct this?

[Anonymous]

Hi, @Yrstruly2021 

Have you resolved this issue please, you can refer to @Zang_Mi  and @Bipin-Lala reply, by the way, thanks very much for their replys. If you are not sure how to use the feature they describe, you can refer to the steps below.

1. Check the Report View interface and select the description column in your table.
2. In the Column tools interface, select Sort by column, and then select index .

3. Create Matrix visual

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Yrstruly2021]

Cant sort by index. 

[Anonymous]

Hi, @Yrstruly2021 

Your description column has multiple identical values, if you want to implement this feature, you have to make sure that your description column is a unique field to be able to do so, and if you can, you need to change the same description of the description column to try to make their values different

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Zang_Mi]

Hello,

As @Bipin-Lala has mentioned, it should work correctly if you have used Sort by Column to sort description. In addition to that, I have noticed that in your visual the records are sorted in ascending order in accordance with the numeric value returned. Please check whether you have clicked on the second column header to sort the records in that way. If this is the case, you should sort again the records in the visual based on description column 🙂.

[Bipin-Lala]

Hi @Yrstruly2021,

That seems weird. Did you use the Sort by Column option in the Column Tools tab to sort accountcode/ description by index column?

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

If I misunderstood your question, could you please provide some more details around it?