Values in Filter (Power Query) appearing, not part of Column Values

[SHS]

Hello,

Anyone else experiencing that values, not part of the data in the column, appearing in the list when trying to filter in the Transform Data/Power Query Editor in Desktop?

It seems like the list is combining the data in the specific column + another column in my dataset. Never experienced this before! - I experience this in any column I try to filter. I have tried to remove the dataset and upload it again, still experiencing the same issue.

[v-shex-msft · Accepted solution]

Hi @SHS,

Can you please share a pibx file with some dummy data that keeping a similar data structure? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[SHS]

Hi @v-shex-msft ,

Seems that the issue has been resolved, have not experienced it since.