Highlight MAX Value in a Chart or Matrix / Table Visual

[@JCC.M.]

I have been looking for this technique. I watched many youtube videos but none of them really explained what they were doing. You did. I had to adjust for my tables and columns, but I did get it to work. Thank you!

[@GoodlyChandeep]

Thank you Joseph :)

[@bzflowerbee]

Again, you always make it so easy to understand. Thank 3.

[@zaraarshad4346]

2:45 why do you also add the index column through which the months are sorted by? why does the DAX does not work without it?

[@wayneedmondson1065]

Awesome Chandeep! Thanks for sharing this great technique :)) Thumbs up!!

[@IvanCortinas_ES]

Excellent resolution. Thank you Chandeep!

[@VictorHugo-bd3bf]

Wow, that was awesome. thank you so much!

[@jagadeeshreddyt9992]

Awesome Solution Chandeep. Thanks for the video👏

[@darrengodkin]

That was a awesome technique and tutorial, definitely using this great tip going forward 👍

[@shihabhussain12]

@GoodlyChandeep how can i select all year with the same visual want to see total year max and min(2001/2002/2003/2004)

[@sivamagesh]

Really good. I have a table with individual cities, regions and national values I wanted to display a chart when I select the region it should display cities, regions and nation all in one chart and colour the region, nation and cities with different colours. Any suggestions please.

[@younuskhan2841]

I used a line chart and visualize date by sales and below create a table visual for date and sales and 10 columns added for more related information so here issue with these both visuals not interacted with each other when I selected date in the line chart it's not affected in a table visual. I want to know the reason for this issue

[@devikhatri2675]

Nice tutorial, can you explain what would happen if we use sum(sales) instead of [total sales ] measure?

[@sahiladya8473]

Awesome... I have 2 values for a month for different categories..... I am showing max value in my table and matrix I want to apply conditional formatting on max and min value present in chart. max is working but min is not out of all maximum values I want to find max and min. Any way to do that?

[@JianEugene]

Great teacher with awesome technique!

[@bharathreddy4267]

Hey chadeep, i was looking for the same scenario. But my measure is showing in the conditional formatting options

[@fergowo]

Thank you so much! I was able to do it and I used another variable for min value using the same logic as you explained :D

[@GoodlyChandeep]

Cool!

[@vijaykrishnan4151]

Thanks for this great technique.

[@SURESHK-hq3wf]

I like the way you explain about each problem❤️

[@GoodlyChandeep]

Glad to hear that

[@arbazahmad7177]

Thanks for this great tutorial 😊

[@SURESHK-hq3wf]

Request you to do one video for UCL , LCL with detailed explanation. Thank you in advance

[@bitips]

And , if insted highlight de maximum I needed to show the total , for example , I have 12 or 6 or 8 months in a line chart with a bar chart at the end showing the total ? Do you accept the challenge ?

[@theindividual839]

Hello, thanks for the video. Can you share the data tables please. I like to generate the same results on my own. Ms excel tables are fine. Thanks.

[@orkhannazarov2781]

Thank you very much! Great explanation.

[@rajeshsabbani337]

Thank you very much...It helped me a lot.

[@GoodlyChandeep]

Glad it was helpful!

[@XeniaD]

hello - why it shighlighting on me many green values and some also grey , basically its highlighting all green values that are high

[@cmaheshbabu9676]

Hi Chandeep, I had a situation where I have to highlight Min and Max average of percentages in each column in Matrix which will change dynamically according to the slicer selection. Could you please help me to sort it out?

[@kamaur01]

Fantastic. Thank you

[@mnowako]

Good one! Thank you.

[@sarveshmore2645]

Thanks Man!

[@hoaninhnguyen6038]

@Goodly Hello man, I want to ask you, if I want to get the 5 largest values ​​to highlight? please guide me

[@GoodlyChandeep]

You'll find your answer in this video www.goodly.co.in/top-n-and-others-power-bi/

[@hoaninhnguyen6038]

@@GoodlyChandeep thank you so much

[@ganeshreddymotakatla6244]

What if the max value is same for two months, will it highlight the those two months right

[@GoodlyChandeep]

Yes it should!

[@moisesgonga1302]

Thanks for share!

[@wynhopkins4023]

Great explanation

[@GoodlyChandeep]

Thanks Wyn, great to have you here!

[@vineetyoutubr5]

Thanks bro 🙏🏿

[@peterdemestre7750]

Sorry to bother again but I resolved the issue outlined below but didn't delete it because someone else might benefit from the answer. The important factor is that the value in the MAXX expression must be an AGGREGATED measure. In this example [Total Sales] is actually a summed measure - e.g. Total Sales = SUM([Sales]). The answer was in the error message - it just took me a while to finally get it ! ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Hi Goodly, love your videos and am wondering if you could help with my problem. When I copy your example DAX code as follows:- MAXX(ALL('Calendar'[Month], 'Calendar'[Index]), [Total Sales] ) I get the following error:- "A single value for column 'Total Sales' in table 'SalesOrderHeader' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result." The SalesOrderHeader table contains only about 3000 orders with the order dates spanning across 3 years. If I use "SUM([Total Sales])" the formula is accepted but the result is not a MAXX - it is the same as "SUM([Total Sales])" without the MAXX. This happens with everything I try including SUMMARIZE and other code that I have found to calculate the max or min value when the value is an aggregated total by date period such as Month. I feel that I am missing something fundamental.

[@sukhomoyb]

Kudoes to you, Chandeep

[@rishabkaushik661]

Bhai yo index m kya h

[@bhushanrakshe6110]

subtract previous day calculated measure value from till date highest calculated measure value.. dax formula..

[@alisanotsleep]

Лучший

[@GovindDeepakKumar]

Super

[@beginho2454]

Cool...

[@SoMahn]

Sample DAX Code from Video... MAX Sales Cf = VAR MAXSALES = MAXX( ALL('Calendar'['Month'],'Calendar'[Index]), [Total Sales] ) VAR Color = IF ( [Total Sales] = MAXSALES, "Green", "Light Grey" // You can also use HEX Codes for colors // "#Dc661e", // "#d3d3d3" ) RETURN Color