Forum Discussion

TaroGulati's avatar
TaroGulati
Helper III
3 years ago

Remove Interaction with page level filter

Hi everyone,    I am not sure if it is feasible but wanted to know your suggestion.    I have two simple tables: Table 1 and tabel 2   Table 2 is filtering table 1 with DIM key. As you ca...
Need Help
TaroGulati's avatar
TaroGulati
Helper III
3 years ago

lbendlin Thank you so much for your comment. I am restricted to use the slicer in this way because in my report i have more then 55 pages and i want to insert the slicer on report level and it is easy to do it from right side pane. On few pages this slicer on the right can affect all the visual and slicers on the page on few it shouldn't, that's why i was trying to find a way to block the interaction. 

lbendlin's avatar
lbendlin
Super User
3 years ago

In general a page level or report level filter is much better than slicers everywhere.

 

You could create a measure that overrides the filter if needed 

  • TaroGulati's avatar
    TaroGulati
    Helper III
    3 years ago

    lbendlin exactly, I am trying to use at page level here but I need to use also at report level. I tried the measure indicated in my post, do you have any suggestion how i can modify?

     

    thanks 

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      You cannot put measures into slicers. Your measure needs to apply to other visuals.

       

      Think about it from the perspective of your report users.  What is the most convenient (and logical) layout for them? Would a disconnected table work?