Forum Discussion
Conditional Formatting comparing cells between two rows
APPD31 and APPD32 will always be a pair. APPD71 and APPD72 will always be a pair.You know that but Power BI doesn't. You need to provide a hint (like a Pair ID) in the data.
It's hard to really display what the expected outcome is but I agree I should try to state what I would like to see in better terms.
Right now we have the Secondary and Primary cells with a green background and white font. I put a highlighted red box around each pair of servers.
I would like to make the green background turn red if there isn't a Secondary / Primary text combination in the field for either pair of servers. At times the servers will change roles in each pair, yet there should always be a Secondary and a Primary server in each group.
APPD31 and APPD32 will always be a pair.
APPD71 and APPD72 will always be a pair.
APPD31 and APPD32 will always be a pair.
APPD71 and APPD72 will always be a pair. You know that but Power BI doesn't. You need to provide a hint (like a Pair ID) in the data.
Correct, I'll need to establish a relationship and then check the condition. I'm quite new to Power BI and trying to do the balancing act of learning Power BI but with an understanding I will likely not use the application that much after this.
As for this case. I created a simple bash script to complete the task and will update the DB table and use that value in the conditional formatting equation.I will close this session but very grateful of the input you gave. Being able to ask questions and get answers from the community makes the task of learning a new application easier.