Forum Discussion
Conditional formatting on the row level
Hi, I have the following matrix and need to highlight the highest and lowest value per row (with a green/red arrow). Conditional formatting gives me the highest and lowest value of the whole matrix. Need to apply it to row level.
The table consist of product - brand (Fosfato diamónico - Bunge) and on the columns is the price for different locations (Buenos Aires, Córdoba, etc).
Many thanks!
Juan
4 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi lbendlin you'll find attached an excel file with an example of what I'm trying to do.
I need to highlight the highest and lowest value per row. I did a conditional formatting manually because there were only a few rows. If I aply conditional formatting to all the rows, it highlist only the highest and lowest value of the whole matrix.
Is there any way to solve this?
Many thanks!
Juan
Many thanks !
Will try it
