Straight Table how to highlight certain row by index ?

[admin11]

Hi All

My PBI file :-

https://www.dropbox.com/s/vtv8z3w9sgm24vb/GL_WORKING%20v008.pbix?dl=0

Paul

[Rigensis]

Hi @admin11 

You can do it by using the in-built conditional formatting.
Click on the table > on right hand side select 'Format' section > Conditional formatting > then go through all the columns, applying Background color to them based on the Index value

And the result should be the one you want

[admin11]

@Rigensis I manage to only highlight index column when i using your approach that is build in feature.

firstly i select Category 

Then i enter number = 14

it does not work. where go wrong ?

Paul

[admin11]

@Rigensis 

Thank you for sharing the alternative , appraoch. what is the advantages of your approach compare with @amitchandak 

Do you need to performance every row , i mean row by row ? or can be highlight the whole row ?

Paul

[Rigensis]

You have to do it for every column, just like with the other option, but you do not have to do it row by row. Just specify, which indexes to highlight, and all rows with those indexes will be highligted in the respective column. 

In general for every option that goes through conditional formatting section, you will have to repeat the same logic for each column.

I just sometimes find it easier to work without the calculated measures as for large datasets they may make the whole dataset slightly slower, and they are harder to read for others, if someone else wants to work on the same file down the line.

[admin11]

@Rigensis 

Thank you very much , this approach have one great benefit , that is i can go in to add more row to be highlighted. 

Thank you for sharing.

Paul

[amitchandak · Accepted solution]

@admin11 , Create a color measure like this

if(max(table[Index]) in {14,33,35}, "red", "white")

and use that is conditional formatting using "field value" option

[admin11]

@amitchandak 

Thank you very much , it work fine.

Paul