Conditional Formatting Table Dynamic

[n4ch3]

Hello,

So, i have this table which is a Scores table in this way:

The order change with Season 'Temporada' and Time 'Jornada', so i need allways has this conditional format no matter what teams are in this places:

(This is ordered by Σ Total Points 'Puntos')

- The first 4 places rows must be in a color1

- The next 3 places rows must be in a color2

- The next 10 places rows must be in a color3

- The latest 3 places rows must be in a color4

Im trying to replicate this.

Thanks for your time, i really apretiatte this since is really important.

Regards.

[amitchandak]

Please refer if this can help

https://community.powerbi.com/t5/Desktop/Background-color-for-a-row-table-matrix/td-p/714419

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...


https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[n4ch3]

Hello, thanks for your answer.

Well, almost, this only works for the first row, but i need something based on the order position like:

COLOUR GLOBAL PROJECT ROW = 

IF (HASONEVALUE(Projects[Project]) ,IF( FIRSTNONBLANK('Projects'[Project] , 0) ,"lightgreen" ,"white" ) ,BLANK() )

IF (HASONEVALUE(Projects[Project]) ,IF( SECONDNONBLANK('Projects'[Project] , 0) ,"lightblue" ,"white" ) ,BLANK() )

IF (HASONEVALUE(Projects[Project]) ,IF( THIRDNONBLANK('Projects'[Project] , 0) ,"lightyellow" ,"white" ) ,BLANK() )

And so on..

[amitchandak]

Can you create it based on Rank or some numeric column?

I tried on years like this

Color Year = if(FIRSTNONBLANK('Date'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Date'[Year],2014)>2018,"red","yellow"))

I tried it on font color. Also, it needs to be applied on all columns to get row colored

[n4ch3]

Again Amit, thanks.

The main problem is this is ordered by the total Score, which is a measure of the points by Season and the sum of the Time (Less than or equal to), so we can include several weeks in this total and diferent totals score by the selection.

What I know is that are going to be allways 20 rows.

[parry2k]

@n4ch3 You need to add rank measure for you score and then use that to get the color and use that color measure in conditional formatting for all the columns in the matrix. for rank, read this post

Color =
SWITCH ( TRUE(),
[Rank] <= 4, "Blue",
[Rank] <= 7, "Yellow",
[Rank] <= 17, "Red",
"Green"
)

You can change above condition as per your business logic.

[n4ch3]

Hellop Parry, thanks for your answer.

That almost give what i'm looking for, please take a look:

But this rank give me some repeat numbers, its possible to include another column to make this unic, for example the Goals at favor 'Goles a Favor'?

This is what i'm using:

Category Rank =

    RANKX(

        ALL(Equipos[Equipos]) ,

        CALCULATE(

            SUM('La Liga'[Puntos])

            )

    )

[parry2k]

@n4ch3 in that blog post which I mentioned earlier there is a section talks about on how to break ties. Go thru that and that will help.