Forum Discussion

mouhsinebella's avatar
mouhsinebella
Regular Visitor
3 years ago
Solved

Problem with Multiple X-Axis Constant line

Hello, 

 

I use several constant X-axis lines to highlight a date range, but the problem is when I filter by date. it yields a result with empty areas and the constant lines always there :

 

 

there's a way to fix this?, 

thank you !

 

  • mouhsinebella , You can use a measure in Constant line , so try a measure like

     

    if(date(2020,06,01) >= minx(allselected(Date), Date[Date]) , date(2020,06,01) , blank())

1 Reply

  • mouhsinebella , You can use a measure in Constant line , so try a measure like

     

    if(date(2020,06,01) >= minx(allselected(Date), Date[Date]) , date(2020,06,01) , blank())