Mark specific row in a table visual

[Anonymous]

Hi,

in my Excel file I have a table with 10 columns and yellow marked rows.
I display this table in Power Bi. Is it possible in Power Bi to mark the rows

'Test 1 first test' and

'Test 2 second test' ,

'Test 3 third test' yellow like in my Excel file ?

Power BI Table visual:

can anyone help me out? many thanks !

[v-cgao-msft · Accepted solution]

Hi @Anonymous ,

Row-based conditional formatting is not supported in Power BI yet, so you need to set conditional formatting for each field in the table visual.

Please new a measure.

colour =
VAR _value =
    CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', 'Table'[Id] = BLANK () ) )
RETURN
    IF ( _value <> BLANK (), "yellow" )

Then set conditional formatting for each field in the table visual.

Result.

Attach the PBIX file for reference. Hope it helps.

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Anonymous · Accepted solution]

Hi,

thank you for the solution, but how can I sort the line so that e.g. under test 1 (marked yellow) all test 1 are displayed and with test 2 (marked yellow) all test 2  ???

thanks a lot

[v-cgao-msft · Accepted solution]

Hi @Anonymous ,

Row-based conditional formatting is not supported in Power BI yet, so you need to set conditional formatting for each field in the table visual.

Please new a measure.

colour =
VAR _value =
    CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', 'Table'[Id] = BLANK () ) )
RETURN
    IF ( _value <> BLANK (), "yellow" )

Then set conditional formatting for each field in the table visual.

Result.

Attach the PBIX file for reference. Hope it helps.

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Anonymous · Accepted solution]

Hi,

thank you for the solution, but how can I sort the line so that e.g. under test 1 (marked yellow) all test 1 are displayed and with test 2 (marked yellow) all test 2  ???

thanks a lot

[v-cgao-msft · Accepted solution]

Hi @Anonymous ，

You can sort correctly by index column.

For example. First add an index column in the Power Query Editor. Close and apply.

Drag the [index] column into the visual and sort in ascending order.

Turn off the text wrap and drag the width of the index column to the minimum.

Attach the PBIX file for reference. Hope it helps.

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Greg_Deckler]

@Anonymous Perhaps if you conditionally format the backgrounds if the cells are blank? You can do this with Rules conditional formatting.