Forum Discussion

Solomon_Guy's avatar
Solomon_Guy
Icon for Advocate II rankAdvocate 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 w...
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. 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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

Solomon_Guy's avatar
Solomon_Guy
Icon for Advocate II rankAdvocate 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.