Determine Trend Positive, Negative, Neutral over Time

Question

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??&nbsp;For example:&nbsp;- I have filtered the DATE to be the previous 18 months&nbsp;- For each company, during that time frame, I would show the Positive, Negative or Neutral TREND.&nbsp;&nbsp;COMPANY&nbsp; &nbsp; &nbsp; MEASURE VALUE&nbsp; &nbsp; &nbsp; TRENDA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PositiveB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NegativeC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; z&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Negative...&nbsp;

anonymous · Answer

pbeeyeqs&nbsp; What is the trend based on? Is there a condition?

pbeeyeqs · Answer

Sorry - TREND is a TREND LINE. Is the line (Slope) positive, negative or neutral.&nbsp;I'll edit my initial question.

v-xuding-msft · Answer

Hi&nbsp;pbeeyeqs&nbsp;,
Do you have a standard value to distinguish trend? For example, 80 is positive, 50 is&nbsp;negative&nbsp;and etc..
Can youplease post some sample data and expected result? Then we can help you as soon as possible.
&nbsp;
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 · Answer

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.&nbsp; &nbsp;&nbsp;My goal is to show all Companies with a Negative Trend (Slope).&nbsp;&nbsp;COMPANY&nbsp; &nbsp; &nbsp; MEASURE VALUE&nbsp; &nbsp; &nbsp; TRENDA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PositiveB&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PositiveC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; z&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Negative&nbsp;

stephras · Answer

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

Forum Discussion

Determine Trend Positive, Negative, Neutral over Time

5 Replies

Related content

Negative to Positive or Positive to Negative

IF Negative value

Convert positive values to negative

Positive and negative filter

change values in column from negative to positive and positive to negative