Forum Discussion

Ben81's avatar
Ben81
Icon for Helper I rankHelper I
3 years ago
Solved

ALL filter ignoring slicer

Hi,   I have a simple YTD chart with a measure in the value field but it's being impacted by a period slicer that I have on a centralised slicer page. I have tried using the ALL flter function but ...
Need Help
  • Ben81's avatar
    Ben81
    3 years ago

    I've managed solve the issue using ALLEXCEPT function! 

     

    Thanks everyone,

    Ben

PickleBear's avatar
PickleBear
New Member
3 years ago

Is your period slicer created from a different table to the one you are putting in the All function? Is so you'll need to switch to refering to the column you are using in your slicer.

Ben81's avatar
Ben81
Icon for Helper I rankHelper I
3 years ago

I've managed solve the issue using ALLEXCEPT function! 

 

Thanks everyone,

Ben