Forum Discussion
Conditional formatting matrix for Multiple Columns based on week
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?
1 Reply
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.
