Forum Discussion

dwauer's avatar
dwauer
Frequent Visitor
2 years ago
Solved

Coloring rows based on values in other rows

Hello Friends,

 

I am new to power bi and i tried to search first for my problem, but couldn't found something to solve.

 

I want color the whole row based on values in one column.

 

Example:

 

 

In first column i have different values like FGEFA2400058 or FGEFA2400864.

I need different color only if value changes.

If values is equal then choose same color for this value.

 

Can somebody help me please?

Thanks very much!

 

Best regards

Daniel

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi dwauer 

     

    You can try the following steps:

     

    1. Add an index column to a table in the Power Query.

     

    If the index column is not added, the effect in the table visualization is shown below.

     

    2. Create several measures as follow:

    Measure = 
VAR _t = ADDCOLUMNS('Table', "Group", RANKX(ALL('Table'), [ID], [ID], ASC, Dense))
RETURN
SUMX(_t, [Group])

     

    formatting = IF(ISODD([Measure]), "orange", "grey")

     

    3. Make the Conditional Formatting settings as shown here.

     

     

    Output:

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi dwauer 

     

    You can try the following steps:

     

    1. Add an index column to a table in the Power Query.

     

    If the index column is not added, the effect in the table visualization is shown below.

     

    2. Create several measures as follow:

    Measure = 
VAR _t = ADDCOLUMNS('Table', "Group", RANKX(ALL('Table'), [ID], [ID], ASC, Dense))
RETURN
SUMX(_t, [Group])

     

    formatting = IF(ISODD([Measure]), "orange", "grey")

     

    3. Make the Conditional Formatting settings as shown here.

     

     

    Output:

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi dwauer 

    Create a measure like below and apply background color for each field

     

    Measure 2 = IF(
    SELECTEDVALUE('Product Lookup'[product_group]) IN {"Food","Add-ons"},"Yellow","skyblue")

     

     

     


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

  • dwauer's avatar
    dwauer
    Frequent Visitor
    2 years ago

    Thanks for your help!

     

    I tried the second tip from Yulia and it works but with one error 😉

     

     

    Why does FGEFA2401038 and FGEFA2401059 have same "grey" color? There are in different rows and the should not group together.

     

    And is it possible to color the whole row?

     

    Thanks for your advice!