Issue trying to replace values in table

Question

Greetings,&nbsp;I have an issue where I'm trying to replace some null values with string on filtered rows where there are 0 on a column. Whenever I apply my replaced values, the filtered icon on the column disappaearsa snd I'm stuck with the new filtered rows.&nbsp;How can I prevent this?&nbsp;&nbsp;Here the Folder column has filtered rows active&nbsp;I replace the null values on Type with a a string like MMMM for example and after I hit okay the filter icon on the Folders column disappears&nbsp;Any help would be greatly appreciataed. Thanks!

peterdeacon · Answer

Hi,&nbsp;&nbsp;I’m having the same issue. &nbsp;I’m filtering on column B and replacing values in column A, but I want to then remove the filter and I cannot figure out how to do so.&nbsp;I don’t seem to be able to find anything similar online.&nbsp;KRPete

marcelbeug · Answer

Power Query is not the same as Excel. The main difference is that values are actualy never changed in Power Query: if you filter on a column, then a new table (identified by the step name) is created and the values that were filtered out are just gone. They are still available in the table that is identified by the previous step.

In Excel: filtered data s still available, but only hidden.

For cosmetic reasons, Power Query displays a "filtered" icon, but only when the step is selected in which the filtering takes place.

When you select any subsequent step, then the "filtered" icon becomes a down-pointing triangle.

It doesn't mean that the filtered data is back. It is just cosmetic.

daemetius · Answer

MarcelBeug wrote:Power Query is not the same as Excel. The main differnce is that values are actualy never changed in Power Query: if you filter on a column, then a new table (identified by the step name) is created and the values that were filtered out are just gone. They are still availbale in the table that is identified by the previous step.In Excel: filtered data s still available, but only hidden.&nbsp;For cosmetic reasons, Power Query displays a "filtered" icon, but only when the step is selected in which the filtering takes place.When you select any subsequent step, then the "filtered"&nbsp; icon becomes a down-pointing triangle.It doesn't mean that the filtered data is back. It is just cosmetic.&nbsp;&nbsp;But if I click apply and close so that the values are reflected on the visuals, then it's just gonna show me the latest table (step as you mentioned) and not the original table with the newly replaced values which is what I am trying to do.&nbsp;&nbsp;I'm getting a report automatically and I want to modify its content within powerbi desktop like replacing null values (since the report has those cells with images that aren't "imported" from the get source option.&nbsp;

marcelbeug · Answer

We seem to be on different wavelengths.&nbsp;A query produces one table (or something else, but let's stick to table), which is the table that is referenced by the step after "in"&nbsp;(which may include some transformation itself). This is usually the last step in your query.In your case, that should be the&nbsp;table with the adjusted values.I begin to suspect now that your step after "in"&nbsp;doesn't refer to the last step in your query.&nbsp;If you want more tables, then you need more queries.Alternatively, you can use parameters.&nbsp;Hopefully, this helps, otherwise please provide some schreenshots with representative (fake) data to illustrate the issue.

danielsossa · Answer

Hello, I have the same problem, did anyone find a solution?

Forum Discussion

Issue trying to replace values in table

6 Replies

Related content

Replacing values with Iterations

Replace Errors values with Null values

Replace values

how to dynamically replace values for multiple columns

Trying to replace errors and replace values dynamically instead of entering static value