Forum Discussion

amol0512's avatar
amol0512
Icon for Helper I rankHelper I
4 years ago
Solved

Matrix Conditional formatting

Hi, I wanted to color format Avg volume for each team in a row. this is data is shiftwise team wise Avg volume. I want to color red green based on Row Total of Avg Volume # in in each row. Green if i...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi amol0512 ,

     

    You could create a measure to get the previous [time range] and then get the coresponding [avg volumn].

    Something like below:

    measure =
var pre_time = calculate(max([[time range]]),filter(allselected('table'),[time range]<selectedvalue([time range])))

var pre_avg = maxx(filter(allselected('table'),[time range] = pre_time&&[team]=selectedvalue(team)),[avg volumn])

return
if([avg volumn]>pre_avg,"green","red")

    At last, add this measure to conditional formatting value.

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amol0512 ,

 

You could create a measure to get the previous [time range] and then get the coresponding [avg volumn].

Something like below:

measure =
var pre_time = calculate(max([[time range]]),filter(allselected('table'),[time range]<selectedvalue([time range])))

var pre_avg = maxx(filter(allselected('table'),[time range] = pre_time&&[team]=selectedvalue(team)),[avg volumn])

return
if([avg volumn]>pre_avg,"green","red")

At last, add this measure to conditional formatting value.

 

Best Regards,

Jay