Coloring rows based on values in other rows

[dwauer]

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

[dwauer]

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!

[v-xuxinyi-msft · Accepted solution]

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]

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