Forum Discussion
Conditional formatting on row level data of matrix table
Hi
I have below data which is converted into a Matrix table in power bi-
I want to apply conditional formatting on the visual where the data bars should compare the specific subject value for all the students. As of now, the cnditional formatting option of power bi allows me to compare the Specific student value of all the subjects. I want to apply row specific conditional formatting & not on column level.
How can I achieve the same?
Visual-
Data-
| Sudent | Subject | Value |
| A | X1 | 11 |
| A | X2 | 9 |
| A | X3 | 15 |
| A | X4 | 19 |
| A | X5 | 8 |
| A | X6 | 5 |
| B | X1 | 10 |
| B | X2 | 5 |
| B | X3 | 8 |
| B | X4 | 8 |
| B | X5 | 10 |
| B | X6 | 11 |
| C | X1 | 9 |
| C | X2 | 7 |
| C | X3 | 13 |
| C | X4 | 5 |
| C | X5 | 17 |
| C | X6 | 14 |
Hi harshadrokade ,
Here are the steps you can follow：
1. Create calculated column.
rank_column = RANKX(FILTER(ALL('Table'),'Table'[Subject]=EARLIER('Table'[Subject])),'Table'[Value],,DESC)2. Format -- Background color – Advanced controls
3. Enter the Background color –Value interface.
Format style – Gradient
What field should we based this on --- Sum of [rank_column]
Check Add a middle color to generate a custom middle color
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
harshadrokade follow the instructions in this great tutorial video:
https://www.youtube.com/watch?v=wTRrskQzAHk&t=8sHi harshadrokade ,
Here are the steps you can follow：
1. Create calculated column.
rank_column = RANKX(FILTER(ALL('Table'),'Table'[Subject]=EARLIER('Table'[Subject])),'Table'[Value],,DESC)2. Format -- Background color – Advanced controls
3. Enter the Background color –Value interface.
Format style – Gradient
What field should we based this on --- Sum of [rank_column]
Check Add a middle color to generate a custom middle color
4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
