Forum Discussion
lawada
Helper III
Helper IIIconditional formatting by row level in matrix visual
i want to apply conditional formatting in a matrix for each row separatly instead of comparing all rows along the matrix for example, in the image below, for each item im grouping data by month and...
Hi,
I am not sure if I understood your question correctly, but please try the below.
I tried to create a sample pbix file like below, and the conditional formatting for the background color can be based on the [Ranking in a group measure].
Value total measure: = SUM( Data[Value] )Ranking in a group measure: = VAR _grouptable = CALCULATETABLE ( Data, ALLEXCEPT ( Data, 'Group'[Group] ) ) RETURN RANKX ( _grouptable, [Value total measure:],, DESC )
Jihwan_Kim
Super User
Super UserHi,
I am not sure if I understood your question correctly, but please try the below.
I tried to create a sample pbix file like below, and the conditional formatting for the background color can be based on the [Ranking in a group measure].
Value total measure: =
SUM( Data[Value] )
Ranking in a group measure: =
VAR _grouptable =
CALCULATETABLE ( Data, ALLEXCEPT ( Data, 'Group'[Group] ) )
RETURN
RANKX ( _grouptable, [Value total measure:],, DESC )