Forum Discussion
francomaestri
4 years agoFrequent Visitor
Dynamic X Axis constant according a filter
Greeting everyone! I have problems with the constant values of the X axis. I have a range filter, but when I use it, I need the constant values outside the range to disappear. Is there an easy wa...
amitchandak
Super User
4 years agofrancomaestri , I created 2 Line and used them on x-axis constant line and they respond to the slicer
l1 = MINX(ALLSELECTED('Date') , 'Date'[Year])
l2 = MINX(ALLSELECTED('Date') , 'Date'[Year])+1
- francomaestri4 years agoFrequent Visitor
Hey, thanks! That's really usefull. Nevertheless, what I needed was to have fixed values for de constant lines. I.E., always on the same years, but to make them disapear when the corresponding year is not in the range of the filter. Any ideas for that?