cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RandimUser
New Member

Getting "Can't display this visual" error

I'm trying to create a slicer on a page where the field is my Request Number.

 

When I put the Request ID field in the slicer it gives me the following error:

 

Can't display this visual. This visual contains one or more filters with deleted columns, type mismatches, or other breaking modeling changes

 

I can seem to find any info on this error or how to debug. Any help would be appreciated. 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @RandimUser 

I actually had this error today.  It was caused by another visual that had a deleted column as a filter.  I guess the cross-filtering capability of visuals was generating the error.

Check all your visuals for deleted columns or measures.

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

5 REPLIES 5
PhilipTreacy
Super User
Super User

Hi @RandimUser 

I actually had this error today.  It was caused by another visual that had a deleted column as a filter.  I guess the cross-filtering capability of visuals was generating the error.

Check all your visuals for deleted columns or measures.

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

v-robertq-msft
Community Support
Community Support

Hi, @RandimUser 

According to your error message, if you don’t have any filters on this visual, I think the problem should exist in the type mismatches or other breaking modeling changes. What’s your data connection mode? Have you changed the column names in the data source file after you connected to the data source with Power BI?

Here's a case that has the same error as yours:

https://community.powerbi.com/t5/Power-Query/This-visual-contains-one-or-more-filters-with-deleted-c...

 

If you still can not find the cause of the problem, you can post the pbix file with this error(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PhilipTreacy
Super User
Super User

Hi @RandimUser 

Can you please supply your PBIX file.

regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


PhilipTreacy
Super User
Super User

Hi @RandimUser 

Select your Slicer then check what Filters are applied to it

slic2.png

 

You may have a column in the filters that you have deleted.

Or there may be a filter that had some criteria applied, for example Show items less than 5 - which is a numeric filter.  If that column has then had its data type changed to Text, that filter criteria becomes invalid.

Remove any filters on your slicer and then reapply them.

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


I don't have any Filter criteria identified for the slicer.  Here is what I have for the slicer and the filter criteria:

 

RandimUser_0-1614097403976.pngRandimUser_1-1614097425512.png

 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors