filtering a column in power query modifies the value of other fields in the table

[Syndicate_Admin]

Hi I need help because I don't understand how this happens.

The situation is as follows when filtering a column in power query changes the value of the records in other columns.

I share the example:

In the original table it is seen in this way the goalId "6226" has a certain value for the last two columns.

but filtering the goalId column equal to "6226" changes the last columns change their value.

What strikes me is that this happens only in some fields and that when you look at the original from where the data is generated in the filtered case you have the correct data.

Please help!

Thank you

[v-jingzhang]

Hi @MarceloAguilar 

Does this table have duplicated 6226 values in goalId column? If it has multiple 6226s, rows may be reordered after filtering rows, so the first row is not the first row before filtering. You can try to filter by the last two fields to check if that row is still present after filtering to only have 6226.

If there is only one 6226, or you cannot find the row by filtering by the last two columns, can you let me know what data source this query is connected to and which connection mode is it (Import or DirectQuery)?

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Syndicate_Admin]

Thank you for your reply,

The record of GoalId 6226 is unique, because this column would be the index of the table so there should not be two identical values.

The source of the data comes from a server in Mysql, so I was seeing by default the connection mode is being imported.

Best regards