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

Get Demo Files here

In this video we're going to go through how you can dynamically highlight the highest / lowest values from your charts using DAX

-

🚩 Support us to get perks such as demo files, early access and more!

MY FAVOURITE POWER BI BOOKS

MY GEAR

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[chavelooo]

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.

[olemew]

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

[archis]

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

[fqflsyr]

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.

[stevewilliams]

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

[Rajesh-gwdi]

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

[carlosgarciamartinez]

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.

[venkateshar]

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

[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.

[sonisatishh]

How did you group month year in calendar table

[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.

[veebee]

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.

[tarikdesilva]

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!

[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?