HIGHLIGHTING DATAPOINTS in Power BI

Learn how to highlight datapoints in Power BI like the max and min value or all values above the average. I will show you how to write the DAX measure, apply the conditional formatting and a little trick to make it work on a line chart. Enjoy!

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
0:46 DAX Measure that returns the maximum
4:15 Adjusting the measure for conditional formatting
6:06 Applying the conditional formatting to datapoints in a linechart
7:40 Different colors for the datapoints on a linechart
9:18 Highlighting datapoints above the average
11:57 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[hendrik-stack]

Its a little bit unbelievable that you know this trick about conditional formatting (turning the chart into a bar chart and then going back to turning it to a line chart to apply the conditional formatting from the previous chart type) but Microsoft should actually go for an easier solution there. Thanks for the video though, it really helped me out :)!

[Soulenergy]

Thank you
3:38 MAXX
5:16 overallmax
5:52 DAX code with MAXX and MINX
6:30 the trick change from line chart into bar chart
7:00 data colors
9:13 Hex Codes

[satishkumardommeti]

Starting with a column chart and later switching to Line chart to highligher markers is a brilliant idea. Hats Off!!!

[JorgeHuamanRobles]

Sin duda alguna el Mejor en ideas de visualización de Datos en Power Bi en todo el mundo. La explicación 10 de 10. !!!
Gracias Bas!!!

[suribhandari]

Hey you are one of the awesome teacher in you tube who teaches power bi

[asad]

The way you explain is exceptional, truly thankful.

[aas]

thats good!!! u earned a new subscriber for urself !

kindly do all variation of this which u told in the end ....it would be a great help

[roshni]

Thanks alot... exactly what I was searching for.. perfectly demonstrated

[Lotaristo]

What i understand is that if you can create a column with desired results in INT format then by applying conditional formatting you can make any colors you want.

[serdalhakanakyuz]

First of all thank you very much for this video. I tried this in power BI firstly without adding quarterno and I noticed that minx is taking the min of same quarters of different years (not the min of all quarters), can you please explain purpose of adding quarterno?

[GG-epvh]

Legendary video! thanks heaps! Just wondering if you could do a demo on where instead of average, its based on a calculated measure ?

[pilarbaldominos]

Hi, another great video. I would be interested to inow if you could you the same logic to the data labels. Thanks

[anastasiakailani]

THIS WAS REALLY AWESOME!Cannot wait to try it out!

[ymohamed]

Great video. Can also use this conditional formatting for the names of the X-axis ? Thanks

[vpalacios]

This is awesome! I needed this six months ago and I wish I knew about this trick but hey it's not too late right? Bas thanks for the demo, this just peaked my brain to wonder what other tricks are available that is not explicitly documented.

[juanignacioXI]

Great work Bas, I have a question. Why Power BI doesnt allow me in the ALLSELECTED type more than one column. For example I just can select ALLSELECTED( Dim_Calendar[Año]) and thats it...

[brightonalbert]

Hey bas, thanks for the video but what if am interested in having to know high and low by year for example highlighting Q3 red and Q4 Green in 2018 and also highlight Q1 Red and Q3 Green in 2019. how would i do that

[ericet]

Always great video, question. I would like to highlight my 10 ten customers on a map. Any suggestions ?

[mansichoudhary]

Hi Bs! That was truly amazing. I am really enjoying learning Power BI watching your videos. Just one quick question, can we make this dynamic from the measures perspective. Like if we drill up to the year level then we see maximum and minimum for year and when we drill down to quarter level we see maximum and minimum for quarter level? Can we do this? Thanks in advance!

[fatbikejamie]

Pure genius. A treat to watch as always 👍😃