Forum Discussion

isly's avatar
isly
Frequent Visitor
9 years ago
Solved

Lock visual to YTD

Hi   I have a report that has a relative slicer, and it effects my one visual when i chage the month difference. i tried to put a only filter on visual level, but relatice slicer still changes the ...
  • Anonymous's avatar
    Anonymous
    9 years ago

Anonymous's avatar
Anonymous
Not applicable
9 years ago

isly's avatar
isly
Frequent Visitor
9 years ago

Hi

 

Not that, that function doesn't work. 

 

i think it should be a dax code, can't quite figure it out. :)

  • kcantor's avatar
    kcantor
    Community Champion
    9 years ago

    isly, the suggestion Anonymous works for my visuals. However, if you are looking for dax, have you considered using ALL within your calculation to force the calculation to ignore that single filter?

     

    • isly's avatar
      isly
      Frequent Visitor
      9 years ago

      Hi

       

      kcantorAnonymous

       

      Thanks, :) yeah it works, but not the kind of way i want it. I have an answer on another forum which i am about to try.