cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Determine which filters/slicers affects a visualisation

When creating a table visualisation in one of my pages, a slicer/filter is applied which is not present in any other visualisation on the page, nor in page level or report level filters. Is there a way to determine where this slicer/filter is coming from? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: Determine which filters/slicers affects a visualisation

SOLUTION

 

Open the selection pane from the view tab to see all the visualisations applied to the page. Check for any hidden slicers and make them visible. I had a hidden slicer which was excluding leave from my visualisation. Simply deleted it and the report was back to functional. 

View solution in original post

6 REPLIES 6
Highlighted
Super User IV
Super User IV

Re: Determine which filters/slicers affects a visualisation

Hope you have checked the visual level filter and if you have not clicked on any other visual by mistake. Also you formula can cause data filtering. provide more details



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Frequent Visitor

Re: Determine which filters/slicers affects a visualisation

I have checked the visual level filters, which do not show the filter I can see under the "filters and slicers affecting this visual." Can confirm no other visual is selected either. The formula I am using that is the most likely culprit is:

 

Unbillable Task Category =
if(Search("Technical Issues",TimeSheet[task],,-1) <> -1,
  "Technical Issues",
     if(TimeSheet[project]="Sales and Marketing",
      "Sales & Marketing",
         if(TimeSheet[Project] = "IT", "IT",
           if(TimeSheet[project] = "Leave",
             "Leave",
              "Uncategorised"
           )
        )
    )
)
 
The filter in question is excluding leave from the visual. Thanks for your response. 
 
Highlighted
Super User IV
Super User IV

Re: Determine which filters/slicers affects a visualisation

The formula seems correct, Unless TimeSheet[task] has blank value and that is one not coming. If you are using a measure with sumx, minx or calculate and having filter that could be the reason for filter

 

If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Support
Community Support

Re: Determine which filters/slicers affects a visualisation

Hi, @Solomon_Guy 

 

Based on my research, you may click the filter icon a1.png in the visual to see filters and slicers applied to the visual.

 

Here is my sample. There are a visual level filter and a slicer filtering the table visual.

a2.png

 

Result:

a3.png

 

Best Regards

Allan

 

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

Highlighted
Frequent Visitor

Re: Determine which filters/slicers affects a visualisation

Hi Allan. yes I am aware of this feature, it is what allowed me to determine a slicer/filter was responsible for my data no displaying correctly. However I do not know where this slicer/filter is coming from. If you have any ideas please let me know. 

 

Thanks. 

Highlighted
Frequent Visitor

Re: Determine which filters/slicers affects a visualisation

SOLUTION

 

Open the selection pane from the view tab to see all the visualisations applied to the page. Check for any hidden slicers and make them visible. I had a hidden slicer which was excluding leave from my visualisation. Simply deleted it and the report was back to functional. 

View solution in original post

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors