How to Change the Bar graphs color to orange only when the 5 consecutive increments of the value?

[Kotebe]

How to Change the Bar graph's color to orange only when the 5 consecutive increments of the value? in power bi
I only changed the color from mar-toJulyy to orange the rest remain blue

Month

Value

Jan	200
Feb	250
Mar	180
Apr	280
May	290
Jun	300
July	350
Aug	150
Sep	179
Oct	800
Nov	200
Dec	400

[v-xuxinyi-msft]

Hi @Kotebe 

Thanks for the reply from Sahir_Maharaj .

The following measures are for your reference, I added an index column to your original data.

Consecutive Increments = 
VAR _CurrentIndex = MAX('Table'[Index])
VAR _CurrentValue = MAX('Table'[Value])
VAR _Prev1 = CALCULATE(MAX('Table'[Value]), FILTER(ALL('Table'), 'Table'[Index] = _CurrentIndex - 1))
VAR _Prev2 = CALCULATE(MAX('Table'[Value]), FILTER(ALL('Table'), 'Table'[Index] = _CurrentIndex - 2))
VAR _Prev3 = CALCULATE(MAX('Table'[Value]), FILTER(ALL('Table'), 'Table'[Index] = _CurrentIndex - 3))
VAR _Prev4 = CALCULATE(MAX('Table'[Value]), FILTER(ALL('Table'), 'Table'[Index] = _CurrentIndex - 4))
VAR _CheckIncrements =
    IF(_CurrentValue > _Prev1 && _Prev1 > _Prev2 && _Prev2 > _Prev3 && _Prev3 > _Prev4, 1, 0)
RETURN
    _CheckIncrements

Color = 
VAR _Index =
MAXX(FILTER(ALL('Table'), [Consecutive Increments] = 1), 'Table'[Index])
RETURN
IF(
    MAX('Table'[Index]) IN {_Index, _Index - 1, _Index - 2, _Index - 3, _Index - 4},
    "orange",
    "blue"
)

Then set the conditional format in format your visual -> Columns -> Color.

Output:

Best Regards,
Yulia Xu

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

[Kotebe]

This a summarized table, How can Like Order date in Table 1 and Date in Date table Product in Tabl1
The one above is only a summarized table from the Date table and Table1 if I add Product to the summarized table I the aggregation is not working 

[Kotebe]

Thank you 

[Sahir_Maharaj]

Hello @Kotebe,

Can you please try creating a calculated column to identify if a bar meets the condition:

Consecutive Increments =
VAR CurrentMonth = 'Table'[Month]
VAR CurrentValue = 'Table'[Value]
VAR PreviousValues =
    TOPN(
        5,
        FILTER(
            'Table',
            'Table'[Month] < CurrentMonth
        ),
        'Table'[Month], DESC
    )
VAR IsIncrement =
    IF(
        COUNTROWS(PreviousValues) = 5 &&
        MAXX(PreviousValues, 'Table'[Value]) < CurrentValue,
        TRUE(),
        FALSE()
    )
RETURN
IF(IsIncrement, "Orange", "Blue")

Then you can apply conditional formatting.

Hope this helps.

[Kotebe]

These gives me all bar chart blue, even though it has orange section 

[Kotebe]

Have you test these code?