Highlight Highest / Lowest AUTOMATICALLY using DAX // Beginners Guide to Power BI in 2021

[@chavelooo33]

Thanks for your videos, what I like it is that are very clear and simple, there are videos less thank 10 mins and goes directly to the point but well explained.

[@kebincui]

Great tutorial, thanks for sharing

[@SolutionsAbroad]

Thanks for watching, much appreciated!

[@CountryViewMeadows]

SOOOO cool!!! Thank you!

[@SolutionsAbroad]

Glad you like it!

[@veebee3969]

Hi Fernan, I created my own Power BI file using the same dataset. I'm unable to replicate $134,630.56 (3:32) on all rows. Instead my file is displaying the monthly sales number on each row. All formulas (measures) are identical between your file and my file. I suspect it is some setting that I have overlooked. In my file I have disabled the "Current File/Data Load/Time Intelligence" which is same as yours. Are you able to suggest where I'm going wrong? Thank You. Update - After spending a whole day, I realised in the Calendar Table, Year and Month columns need to be there before creating 'Month Year' group. In few attempts where I created the just the date column only (no other columns) in the Auto Calendar and then went on to create the 'Month Year' group, the visuals did not give the Max value on each row. I thought 'Month Year' group was coming from the Date column and other columns are not important. Appreciate, if you can briefly explain the logic. Thank You.

[@marlonetzel6450]

good video. Thanks for helping :)

[@sravankumar1767]

Nice explanation 👌

[@SolutionsAbroad]

Thanks for watching!

[@stevewilliams9753]

Very cool. Can you do a similar video highlighting the first and last data values using DAX?

[@SolutionsAbroad]

Hi Steve, of course but I think it will be the exact same solution as this (MINX and MAXX can work on first / last text or dates too) Can you give me a scenario you're looking at using this?

[@stevewilliams9753]

​@@SolutionsAbroad Was looking to highlight first and last data point on a line chart. And was curious to see if DAX was similar. Thanks.

[@carlosgarciamartinez3380]

Hi Fernan. I have a situation to try applying this use case. My Column chart has two values on X-axis ( Year, Month) and when I tried to apply your recommendation did not do anything. Could You help me or make a video of how I can do it.

[@jobimaxia]

Hi, I created a table showing affected employees and facilities and their distance to the nearest disaster area, but I can't translate it into a card or bar graph. The table is filtered by Is Within Threshold. How do I go about it? Appreciate the help. Thanks.

[@gabrielgordon]

Great! Thanks

[@SolutionsAbroad]

You're welcome!

[@SambitPriyaranjanSahoo]

this video is useful but can we change the tooltip for the highest one?. for the highest one in tooltip i need only the quarter and highest to be shown.

[@tarikdesilva5143]

Hi, this video was so useful. Just curious, would the same workflow work if I wanted to create a “personal best” sales amount card, based on category( for eg- for oranges, the highest sale historically was $xyz ?? And this would be replaced if a higher sale was recorded in future? Would really appreciate your help with this!

[@chinnakotlaprakash7490]

Nice bro ❤️

[@SolutionsAbroad]

Thanks 🔥

[@olemew]

To highlight lowest and highest you can always use the in built conditional formatting, playing with =0 and =100 percent.

[@SolutionsAbroad]

Hi, I've never thought about using that, great idea, thanks!

[@welcometomathy]

hi can you make it work with only SelectValues from the date table? I might want to filter dates to see only last 12 weeks but if the high or low ain't on those dates it doesn't work.

[@archis0605]

First of all these video is very useful but if i want min max for each year then how could we do that ?

[@kckingle8370]

Thanks!

[@SolutionsAbroad]

Thanks for that!

[@Luis.C.Canchan]

Muchas gracias.

[@SolutionsAbroad]

You're welcome!

[@vanishedxu]

Is it possible to apply different colors to y ticks based on a categorical column? There is conditional formatting for y ticks, but I've failed miserably hundreds of times trying. For example, on a horizontal bar chart showing countries by population where country names are the y ticks, is it possible to make say all European countries one color and other countries another color?

[@SolutionsAbroad]

Hi Van, not sure I got the question here. If you're using a bar chart, you should be able to create a measure with a SWITCH statement that manually changes your European countries colour, basically similar to what I've done in the report. If you explain to me a bit more perhaps I can try to help you

[@vanishedxu]

@@SolutionsAbroad Hi Fernan, I did create a measure with a SWITCH statement that returns "Red" when the population is over 50 million and "Green" when below. It works great on formatting the bar colors. But when I applied the same measure on the Y axis text (different country names in words), I would expect to see the same color variance and it doesn't work there. It always shows one color for all countries, no matter what the bar color is for that specific country. I wish I could upload a screenshot so I can make myself more clear.

[@Rajesh-gw7di]

i have used the same code but i am getting all bars with green only can u explain why ? Highlight max/min = VAR _highest= MAXX(ALLSELECTED('Calendar'[Year Month]),[total_sales]) VAR _lowest= MINX(ALLSELECTED('Calendar'[Year Month]),[total_sales]) VAR _highlight=SWITCH(TRUE(), _highest=[total_sales],"Green" ,_lowest=[total_sales],"Red" ,"Gray") RETURN _highlight

[@sonisatishh07]

How did you group month year in calendar table

[@venkateshar7483]

Please explain how to create power bi online account in cloud by using gmail

[@SolutionsAbroad]

Hey mate, I've covered that here in this video: kzbin.info/www/bejne/sIqunmuvd8qqh7c