Forum Discussion
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 ...
Hi v-jiascu-msft kcantorAnonymous
The answer in another forum didn't work .
I used the method mention above, but with our own date diff calculation i get first month of the year to active month. by doing that, i locked the visual being filterd by relative slicer and only getting it's own date diff calculation to show months.
You may need to duplciate any measures just for this Visual. If it's not a Slicer interaction issue, one of your caculations might be changing your YTD values b/c it's sharing a measure being effected by another slicer. Make unique YTD Measures just for this visual (and double check your slicer interactions one more time.)
P.S. Some sample data would really help here...
FOrrest
