Conditional formatting on row level data of matrix table

[harshadrokade]

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

[Anonymous · Accepted solution]

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

[SpartaBI]

@harshadrokade follow the instructions in this great tutorial video:
https://www.youtube.com/watch?v=wTRrskQzAHk&t=8s