Forum Discussion

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

line graph coloring based on

Hi there,   I have three measures that created the lines on a line graph as shown below.    Now I don't want to display the Upper limit and lower limit lines for the months that are gone. F...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    Dunner2020 , Try like

     

    Upper Limit new = if(max(Date[date])> eomonth(today(),0), [Upper Limit], [Actutal value])

     

    Lower Limit new = if(max(Date[date])> eomonth(today(),0), [Lower Limit], [Actutal value])

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
6 years ago

amitchandak Anonymous , wow it works. Thanks for the reply. 

 

 

 

Before I accept the reply as a solution, quick question is it possible to joint the upper and lower limits to the actual value line for the passed months (as shown in the picture)

 

 

I tried the following measures to generate similar thing:

Lower Limit new =
Var _CYMonth = MONTH(TODAY())
Var _RYMonth = if(_CYMonth > 3 && _CYMonth <= 12, _CYMonth - 3,_CYMonth + 9)
Return
IF(max(Dates[RY Month Number])> _RYMonth, [Lower Limit], [Actual Value])
 

 

Upper Limit new =
Var _CYMonth = MONTH(TODAY())
Var _RYMonth = if(_CYMonth > 3 && _CYMonth <= 12, _CYMonth - 3,_CYMonth + 9)
Return
IF(max(Dates[RY Month Number])> _RYMonth, [Upper Limit], [Actual Value])

 

It produced the following output

 

As you can see that the color of actual value is changed and to brown. Is there any way of doing that?

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Dunner2020 , Try like

 

Upper Limit new = if(max(Date[date])> eomonth(today(),0), [Upper Limit], [Actutal value])

 

Lower Limit new = if(max(Date[date])> eomonth(today(),0), [Lower Limit], [Actutal value])