Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
72 | |
66 | |
34 | |
25 | |
22 |
User | Count |
---|---|
96 | |
94 | |
58 | |
45 | |
42 |