Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Bug with Filtering and Sorting in Data View

Submitted by Anonymous on ‎06-22-2018 02:52 PM

Using the latest version of Power BI Desktop (Version: 2.59.5135.421 64-bit June, 2018), I noticed that Filtering and Sorting in Data View can produce incorrect results. 

 

As an example, I imported from a database and added a couple calculated columns using RANKX. After filtering for a certain value, I noticed that sorting by different columns did not sort the entire dataset. Or in other words, the values in each row were not aligned correctly; the sorting only applied to certain columns.

 

I wouldn't think this would be the intended behavior as this can make data model validation and testing very difficult. 

 

Appreciate your help with this. 

 

Thank you

Status: Needs Info
See more ideas labeled with:
3 Comments (3 New)
Comments
v-yuezhe-msft
Employee
Employee
‎06-25-2018 01:20 AM

@Anonymous,

Could you please share a small dataset so that we can test? Also we want to know which columns you use to sort and what is your expected result.

Regards,
Lydia

Vicky_Song
Impactful Individual
Impactful Individual
‎06-26-2018 02:46 AM
Status changed to: Needs Info
 
Anonymous
Not applicable
‎06-26-2018 06:11 AM

Hi Lydia, 

 

I'll try to reproduce the issue with a sample dataset as the issue occurred with company data. 

 

Thanks

Robert

Idea Statuses