Forum Discussion

Dunner2020's avatar
Dunner2020
Post Prodigy
5 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
    5 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])

amitchandak's avatar
amitchandak
Super User
5 years ago

Dunner2020 , Set you upper limit

 

limit

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

 

lower Limit new = if(max(Date[date])> eomonth(today(),0), [lower Limit], blank())

Dunner2020's avatar
Dunner2020
Post Prodigy
5 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
    Super User
    5 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])

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks :). Amit already my solution to your question.😊