Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Rows can be coloured with the std conditional formatting, but you have to format each of the columns.
I usually have a colour field that can then be referenced in the Conditional Formatting format by field value.
e.g. You can use names or colour numbers
MaxValue1Col = SWITCH( max(Table1[Column1]), 1,"Green",2,"Red", "LightBlue")
Headers not with a std table. I think they are working on dynamic format expression that could help in future versions.
However you can fake it with 2 tables.
Edit Data to add a new table of the headers. You can the make a table from these and conditional format them
Make the header font the same colour as the background and overlay the header table above the other table.
Rows can be coloured with the std conditional formatting, but you have to format each of the columns.
I usually have a colour field that can then be referenced in the Conditional Formatting format by field value.
e.g. You can use names or colour numbers
MaxValue1Col = SWITCH( max(Table1[Column1]), 1,"Green",2,"Red", "LightBlue")
Headers not with a std table. I think they are working on dynamic format expression that could help in future versions.
However you can fake it with 2 tables.
Edit Data to add a new table of the headers. You can the make a table from these and conditional format them
Make the header font the same colour as the background and overlay the header table above the other table.
User | Count |
---|---|
103 | |
87 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |