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: ...
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.

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity 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