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:
Does it require DAX or can I execute it using the formatting options?
Thanks again,
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?