Conditional formatting matrix for Multiple Columns based on week

[Jefferbur_]

Hi!

Hopefully someone can help. I am struggling to recreate something that was previously done in excel into a Matrix visual in one of my reports. 

Basically, I am trying to display gradient colors using conditional formatting based on the values for multiple columns. In excel, we used conditional formatting for each individual column multiple times. 

When I attempt to use conditional formatting in Power Bi, the entire dataset is used in the gradient rather than each individual column. I have also tried creating a color table using dax and then use a gradient color measure within field value but the colors are all over the place. 

Does anyone have any suggestions?

[lbendlin]

That is a standard pattern where you use a measure for the color.  In the measure you can remove the row filter so that it works for the entire column.