Forum Discussion

Tobias106's avatar
Tobias106
Icon for Helper I rankHelper I
3 years ago
Solved

Constant line on 2nd y-axis

Hello,   I have in my table a date colum. Also I have calender table.   I would like to integrate a constant line with the value 28 in my graph (stacked column with line).   In the analytics pa...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Tobias106 ,
    You can rewrite your measure as : 

    Measure = IF( SELECTEDVALUE(Packing[Date]) >= DATE(2021,1,1) && SELECTEDVALUE( Packing[Date]) <= DATE(2022,12,31), 28, BLANK())
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Tobias106 ,
You can rewrite your measure as : 

Measure = IF( SELECTEDVALUE(Packing[Date]) >= DATE(2021,1,1) && SELECTEDVALUE( Packing[Date]) <= DATE(2022,12,31), 28, BLANK())