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.

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.