Forum Discussion

pbeeyeqs's avatar
pbeeyeqs
Icon for Helper I rankHelper I
7 years ago

Determine Trend Positive, Negative, Neutral over Time

Is there such a way to create a DAX measure in Power Bi showing whether TREND LINE (Slope?) is Positive, Negative or Neutral over time based on a value such as sales??  For example:   - I have f...
Need Help
pbeeyeqs's avatar
pbeeyeqs
Icon for Helper I rankHelper I
7 years ago

Sorry - TREND is a TREND LINE. Is the line (Slope) positive, negative or neutral. 

I'll edit my initial question.

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi pbeeyeqs ,

Do you have a standard value to distinguish trend? For example, 80 is positive, 50 is negative and etc..

Can youplease post some sample data and expected result? Then we can help you as soon as possible.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • pbeeyeqs's avatar
    pbeeyeqs
    Icon for Helper I rankHelper I
    7 years ago

    Here's an example, say this represents 3 companies, the GREY line (Company A) is a positive trend over time, the ORANGE line (Company B) is a positive trend, and the BLUE line (Company C) is a negative trend over time.   

     

    My goal is to show all Companies with a Negative Trend (Slope). 

     

    COMPANY      MEASURE VALUE      TREND

    A                                x                         Positive

    B                                y                         Positive

    C                                z                         Negative

     

    • stephras's avatar
      stephras
      Frequent Visitor
      4 years ago

      Did you ever find a solution to this? Looking for something similar.