Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
rayishome
Resolver I
Resolver I

Datasource Sorting & Sort By Column isn't working within Excel

Sorting by another column works fine in Desktop and the service, but the same pivot table in Excel will not sort correctly.  Is there an outstanding issue?

1 ACCEPTED SOLUTION

I figured out the issue.  We have multiple sorting values for the same member value.  Looks like PBI is selecting a random value as it's sort value vs using the Sort value within the group. 

 

We have data that looks like this

 

Product Cat

   Product, Product Sort

 

Cars

       Door, 1

       Radio, 2

 

Trucks

      Door, 2

      Radio, 3

 

 

  

View solution in original post

2 REPLIES 2
collinq
Super User
Super User

Hi @rayishome ,

 

Yo uare going to have to be a bit more specific.  What is the column you are trying to sort?  What are you expecting it to look lik?  What does it actually look like?  What part of the field are you sorting on?  Please provide some screenshots and more detail.

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




I figured out the issue.  We have multiple sorting values for the same member value.  Looks like PBI is selecting a random value as it's sort value vs using the Sort value within the group. 

 

We have data that looks like this

 

Product Cat

   Product, Product Sort

 

Cars

       Door, 1

       Radio, 2

 

Trucks

      Door, 2

      Radio, 3

 

 

  

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors