Forum Discussion

Kds1113's avatar
Kds1113
Helper I
3 years ago
Solved

Customized Order for Rows or Columns

I'm having similar issues on 2 reports I'm creating.    In the first, I need to display the rows in a specific orders, as well as the items in the slicer that displays across the top of the report....
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Kds1113 ,

    I have created a simple sample, please refer to it to see if it helps you.

    Add an conditional column in Power Query.

     

    Then put the fields into the matrix. Click the Fund source column.

    Finally sort the Fund source column by Custom.

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Polly

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Kds1113 ,

Do you want to change the rank in the data?  Sorting of the data interface is the default. We cannot change it. But you can change it in the visual .

Select a matrix.

Then put the fields into the matrix. Click the Fund source column.

 

Finally sort the Fund source column by Custom.

 

Best Regards
Community Support Team _ Polly

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

Kds1113's avatar
Kds1113
Helper I
3 years ago

Anonymous Thanks, I figured out what i was doing wrong.  I was changing the sort by columns from the data section, not realizing that it is available in the report section by clicking on the field name in the fields menu.  Settingthe order on that way worked perfectly.