cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
music43
Helper I
Helper I

Filter of unknown origin

Hi

 

I am working on an inherited report. I have just copied and pasted a clustered column chart.

 

The original chart has 4 fields in the "filters and slicers affecting this visual". Three of these are "Filters on this visual" and the other is from the "Filters on this page" pane.

 

The pasted chart (pasted on the same page) has 5 fields in the "filters and slicers affecting this visual". Three of these are "Filters on this visual" and the other is from the "Filters on this page" pane.

 

Can anyone suggest where I should look to clear this filter and out of interest HOW this is happening from a copy/paste function.

 

Thanks everyone

 

6 REPLIES 6
jprdynamicapps
Helper III
Helper III

I'm having the same issue as the OP.  In my case, I think it is a "stuck" drill-through filter.  I originally created this page as a drill-through but then changed my mind.  A field shows up in "filters and slicers affecting this visual" but does not show in the fitlers pane and there is nothing in drill-through.  Clearing cache did not work.  Saving the file and opening it again did not work. Ideas?

Experimenting further with this, it appears to be an issue with "sync slicers".  I'm getting some other strange behavior such as not being able to create a slicer that isn't synced to others on the same field even if they have different names. 

v-deddai1-msft
Community Support
Community Support

Hi @music43 ,

 

Would you please try to update your desktop to the latest version? It work wells in my test, would you please show us sample pbix by onedrive for business for getting to the root of the issue?

 

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

 

Best Regards,

Dedmon Dai

amitchandak
Super User IV
Super User IV

@music43 , Filter on visual and page , you should be able to clear from filter pane on he right hand side ?

If I got the problem correctly.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Sorry if I wasn't clear. I can't see the other filter to clear it.

I copied the chart (bottom of the screenshot) and pasted it above. As soon as I paste the visual changes and only shows 4 months instead of 12. The new filter that appears from nowhere is Current Financial Year. I don't know why it appears or where it I can clear it from...

 

music43_0-1610116510659.png

 

@music43 . This is something really strange. The only suggestion I have is; under options and setting there is an option for clear cache, use that and copy again and check.

 

If needed save a copy of file and try in new file.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors