Forum Discussion

harshadrokade's avatar
harshadrokade
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

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 al...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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