Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Mark specific row in a table visual

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 !

 

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
    Anonymous
    4 years ago

    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

  • Anonymous's avatar
    Anonymous
    4 years ago

    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

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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