cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
admin11
Post Prodigy
Post Prodigy

Straight Table how to highlight certain row by index ?

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

7 REPLIES 7
Rigensis
Helper I
Helper I

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

Rigensis_0-1613487191677.png

 

Rigensis_1-1613487352174.png

And the result should be the one you want

Rigensis_2-1613487486889.png

 




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

firstly i select Category 

admin11_0-1613491315059.pngadmin11_1-1613491375515.png

Then i enter number = 14

admin11_2-1613491394794.png

 

it does not work. where go wrong ?

Paul

 

@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

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.

@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
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

@amitchandak 

Thank you very much , it work fine.

Paul

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.