Forum Discussion
Solved
conditional format single value in matrix
Is there a way to conditionally format a single value (highest or lowest) in a matrix? For example, I'd like to show a matrix for product sales by year and month and wish to highlight the highest (b...
Hello funklordofusa
I have uploaded the pbix file for you here: https://1drv.ms/u/s!AiiWkkwHZChHj1wR7sFzNd8m2f1E
To add the conditional format, based on a measure, follow these steps:
here is an example of the data:
| Year | Value | Month |
| 2014 | 12560708 | January |
| 2014 | 16968413 | February |
| 2014 | 32218982 | March |
| 2014 | 33815386 | April |
| 2014 | 34307532 | May |
| 2014 | 31979161 | June |
| 2014 | 30774413 | July |
| 2014 | 32989330 | August |
| 2014 | 33241923 | September |
| 2014 | 34139505 | October |
| 2014 | 30947137 | November |
| 2014 | 30006435 | December |
| 2015 | 27099854 | January |
| 2015 | 26485375 | February |
| 2015 | 29681380 | March |
| 2015 | 28544525 | April |
| 2015 | 28115709 | May |
| 2015 | 29731018 | June |
| 2015 | 28943291 | July |
| 2015 | 29251503 | August |
| 2015 | 31384637 | September |
| 2015 | 30475097 | October |
| 2015 | 29602103 | November |
| 2015 | 29923197 | December |
| 2016 | 25264531 | January |
| 2016 | 26180127 | February |
| 2016 | 31969361 | March |
| 2016 | 30913398 | April |
| 2016 | 30220235 | May |
| 2016 | 27319953 | June |
| 2016 | 27480557 | July |
| 2016 | 29376793 | August |
| 2016 | 28281471 | September |
| 2016 | 28185455 | October |
| 2016 | 26852441 | November |
| 2016 | 26481810 | December |
| 2017 | 24467862 | January |
| 2017 | 24465064 | February |
| 2017 | 28012538 | March |
| 2017 | 27241900 | April |
| 2017 | 31930123 | May |
| 2017 | 28809465 | June |
| 2017 | 24565075 | July |
| 2017 | 32738664 | August |
| 2017 | 28046908 | September |
| 2017 | 30480059 | October |
| 2017 | 28961507 | November |
| 2017 | 24878892 | December |
| 2018 | 27362760 | January |
| 2018 | 26066138 | February |
| 2018 | 31129519 | March |
| 2018 | 30538616 | April |
| 2018 | 28978045 | May |
| 2018 | 29283051 | June |
| 2018 | 27297204 | July |
| 2018 | 32818608 | August |
| 2018 | 28934255 | September |
| 2018 | 36256115 | October |
| 2018 | 29721993 | November |
| 2018 | 23268130 | December |
| 2019 | 26656224 | January |
you want to highlight the highest monthly values within each year or the highest overall?
highest overall, please.
Hello funklordofusa
I have uploaded the pbix file for you here: https://1drv.ms/u/s!AiiWkkwHZChHj1wR7sFzNd8m2f1E
To add the conditional format, based on a measure, follow these steps: