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. 

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.