Forum Discussion
Solved
VARIABLE: UNDESIRED BEHAVIOR
Hi, I have a line chart where I want it to show the data only until the selected month. This is the metric that I created with a variable that returns that month's number. The result of the ...
See the attached file for an example. Like I said, this is a quick and dirty solution. You should eschew the auto date/time feature altogether and create your own date table that can be used in the slicer The auto date/time feature can be turned off at
Options and settings->Options-> Current File -> Data Load ->Time Intelligence
and at
Options and settings->Options-> Global -> Data Load ->Time Intelligence
Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.
Cheers
I'll give you a very good piece of advice: PLEASE REFRAIN FROM USING THE AUTOMATICALLY GENERATED CALENDAR HIERARCHIES. Instead, build your own calendars if you want to be on the safe side and develop without surprises.
Best
D.
Best
D.