Forum Discussion

LR's avatar
LR
Frequent Visitor
8 years ago

Automatically count the number of consecutive points decreasing / increasing

Hi Team ! I would like to highlight areas on a graph where 6 consecutive points (or more) are increasing or decreasing. How to perform such calculation ?  Regards       ...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI LR,

 

Current power bi not contains similar feature to achieve your requirement.

 

In my opinion, I'd like to suggest you write calculated column to check your records status to add category tag when they suitable for your requirement.

 

After these steps, use above column as chart legend and manually modify its data color of tagged category.

 

BTW, current power bi not support use multiple value field and legend field at same time.

 

Regards,

Xiaoxin Sheng

LR's avatar
LR
Frequent Visitor
8 years ago

Hi Anonymous,

Thank you for your response !


I tried to create 2 new columns : one for consecutive increasing points and one for consecutive decreasing points.
I created a third column too. It serves to highlight areas on the graph :

     IF (
           OR (
                    [PointsIncreasing] >= 6 ;
                    [PointsDecreasing] >=6
           );
          'Table'[Value] ;
          Blank()
     ) 

 
I don't know yet how to counts the increasing/decrasing number of consecutive points.
Do you have any idea or research leads ?

Regards
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi LR,


    Unfortunately, current charts not support use multiple values and legend at same time. I don't think you can use that method to achieve your requirement.

     

    Can you please share some sample file to test and coding formula?

     

    Regards,
    Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI LR,

         

        As I said, you can simply use below column formula to mark tags of each records.

         

         

        Category =
VAR previous =
    MAXX (
        FILTER (
            ALL ( Table1 ),
            [Type] = EARLIER ( [Type] )
                && [Date] < EARLIER ( [Date] )
        ),
        [Values]
    )
VAR result = [Values] - previous
RETURN
    IF (
        previous <> BLANK (),
        IF ( result > 0, "increasing", IF ( result < 0, "decreasing" ) )
    )

         

         

        BTW, current power bi not support multiple legends or combine use legend fields and multiple value fields, so I think you can't use these columns to create graph in power bi .

         

        Regards,
        Xiaoxin Sheng