Forum Discussion

Solomon_Guy's avatar
Solomon_Guy
Advocate II
6 years ago
Solved

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? 

Need Help
  • Solomon_Guy's avatar
    Solomon_Guy
    6 years ago

    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. 

7 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    6 years ago

    Hi, Solomon_Guy 

     

    Based on my research, you may click the filter icon  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.

     

    Result:

     

    Best Regards

    Allan

     

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

    • Solomon_Guy's avatar
      Solomon_Guy
      Advocate II
      6 years ago

      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. 

      • Solomon_Guy's avatar
        Solomon_Guy
        Advocate II
        6 years ago

        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. 

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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

    • M_t_cardoso's avatar
      M_t_cardoso
      Frequent Visitor
      3 years ago

      Hi, I do have a question about this. I have a dashboard with a lot of visuals, and clicking on them affects the remaining ones.

      How can I instantly know which one is affecting the others? Or how can I make them unrelated, so that cliking on them does not affect others?

    • Solomon_Guy's avatar
      Solomon_Guy
      Advocate II
      6 years ago

      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.