Forum Discussion
Issue trying to replace values in table
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.
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.
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.
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.
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.