Cannot remove filter after changing data model

Frede ,

I have made a test on this issue but couldn't reproduce this issue. The filter can be removed after the column being deleted in power query/data source.

Please update power bi desktop to the latest version.

Regards,

Jimmy Tao

Hi Jimmy,

I have the November 2019 release so that is not the issue. I cannot reproduce the issue either but you can clearly see the problem in the video. It can depend on other fields that was altered in Power Query as well as I made several changes. I have however deleted and re-created the matrix visual.

Thanks

Fredrik

Still having this issue in 2023. It broke ALL of my charts somehow, even the ones not using that data source. Added a relationship between two date/time types and it broke everything, all of my charts can't be displayed because it says something about that field is invalid. I can't afford to remake every chart. Deleting the column entirely does not let me remove the filter either

<does nothing>

Instead of re-creating all visuals maybe it is easier to 

1. re-create the columns in the data source

2. Validate that the report does render

3. remove the filter

4. Delete the columns again.

Have not tried this myself though.

If the datamodel changes you are sometimes in big trouble with linked visuals. Even Measures are removed from a report with a live connection to that datamodel. Recreating measures gives a simular but different error. 

I solved this by diving a little deeper in the structure and hard replaced filters which I used with an existing field in the filters.json file that every visual has  using this post

https://data-goblins.com/power-bi/replace-report-measures

and the pbi-tools

https://pbi.tools/

and some powershell scripts to automate the replace of fields in filter

Get-ChildItem -Path C:\Tools\extract\Report\sections\* -include filters.json -recurse | rename-item -newname { [io.path]::ChangeExtension($_.name, "txt") }
Get-ChildItem -Path C:\Tools\extract\Report\sections\* -include filters.txt -recurse |
Foreach-Object {
write-output ($_.FullName)

$a = ($_ | Get-Content)

$c = $a -replace 'unexistingfield ', 'existingfield'
[IO.File]::WriteAllText($_.FullName, ($c -join "`r`n"))
}

Get-ChildItem -Path C:\Tools\extract\Report\sections\* -include filters.txt -recurse | rename-item -newname { [io.path]::ChangeExtension($_.name, "json") }

remove everything from the data columns and rows field, remove all and re-insert -- I used this method and works for me -- but it would be good that MS developer make some documentations to this because this happened to me this week as well