Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Many thanks !
Will try it
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-...
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/1447523
Hi @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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |