 Hello everyone and welcome back to another tutorial looking at Power BI. So the format for this video is probably gonna be a shorter one but I simply want to cover off how to use conditional formatting within Power BI. And the example we're gonna use is just having a simple table here and we'll just go through some like say very entry level conditional formatting just to show you how to get started and obviously you can do a lot more complex criteria than what we're gonna be looking at today. So we can see our criteria we've got here on the left. So we want to have any values that are less than three. We want them to be red and when I say red I want the background of the cell to go to the color red. If it's greater than or equal to three but less than seven we want those numbers to be amber. So all numbers between and including three up until any that are less than seven we want to be amber and then if it's greater than or equal to seven we want that value to be green and We haven't got any values that go up to there But we're just going to base this on numbers being ranging from one to ten So obviously ten would be our our ceiling in this example So we're going to do it based on our totals column obviously you could do this again on sales But based on our criteria We're only going to apply this to the total number here and let's say these are units of sales So basically we want to aim to achieve seven sales on each day Hence that's why it would make it green and obviously the other colors wouldn't indicate any days of the week that we need to sort of Improve our sales So in order to do conditional formatting all we need to do if we select our table that I've already put into here And this is nothing more than a basic simple table I've put in here containing what we can see on the screen So you've got the day the number of sales and then the sales total and as we can see the days Are actually in order here at the moment because I've not actually done anything complex with that But then they will probably serve the purpose of this tutorial So all we're going to do to add our conditional formatting is we want to do on the total field So I'm going to navigate to the right-hand side in our visualization pane here And we can see the values that make up our table All I'm going to do is go to the total field and you see the little drop down We have here click that and we can then come down and clearly see we've got the option here for conditional formatting There's a number of options. We've got available Namely, you've got background color or font color with our conditional format We're looking at today. We're going to be sticking with background color But again, you could use the same logic to do the font color if that was your preference And we've got some other options here available, but we'll be going over those in other dedicated videos So we can see that when we click that button We have some options that appear to us and by default it gives us the option to do a color scale based on obviously The lowest versus the highest value, which is a great option It gives you some flexibility if you've got a bigger table and you're trying to identify What are the highest and lowest values in that range? But for us, we want to apply our simple logic So we're going to change the drop down here from color scale to rules and you can see how the view has changed for us slightly and The options we've got here So apply to values only based on the field and it's going to be the sum of total and you can see the Summarization is some so we've summarized just by some on this field at the moment But again more flexibility available to you here if you wish to do so So what I'm going to do is I'll start at the bottom So we're going to look at our lower range numbers first and we'll build the criteria from then so what we're going to do here if we go is greater than or equal to Zero because zero could be a sales one of our days and we'll change that to a number and is less than Three so obviously this is our bottom one was going to be red We want those the background of that cell to go to the color red and I can't see a clear red here So all I'm going to do is go custom color and we can sort cherry pick a color here like so Click okay, and we can see that rule has now applied So any numbers and for us is the only the number two on Sunday You can see the background color has now changed to red So we know that is working what we can further do so if you go back into our total field Do our drop down conditional formatting and background color We can now continue on building our rules. So this first one's working great So we now need to click this button here of new rule so that we can add a new rule into our criteria So this one is then going to be if there is greater than or equal to three So obviously now moving on from our one we've set out here and it's obviously going to be number again And is less than number seven Then we want our color to now be amber. So all we need to do now again go custom color Find where about a nice amber is so let's go somewhere here. Yeah, it looks about nice orange Click okay, and we can see that again has now populated all those other backgrounds So you don't need to keep coming out of the conditional formatting every time like I'm doing I'm simply just doing it so we can see how this builds up as we progress through each of our criterias So the last one we now need to do is those greater than seven So all we're going to do for that is again go back into our conditional formatting background color And we need to do add a new rule So the last one we've got to do here is is greater than Is greater than or equal to well wonder if we can actually do is now we need to go is greater than or equal to Seven and is less than or equal to say the number ten So yeah, it's greater than or equal to seven and it needs to be number here We went over that one and is less than or equal to ten then we want to do a green So go into here find a nice green perfect So I've got red and our amber and our green Obviously as I said before our number range is only going to go up to ten But should any numbers come in that are going to be higher than ten obviously it's not going to be picked up in our Criteria Therefore we would need to adjust this number here to make sure we include those or if we didn't want to obviously We wouldn't need to do any more rules it would just show them as no formatting to the cell or Alternatively, we could add another rule if required to pick up those new numbers So some best practice might be on this part here even though we only want these and we know it's going to get to ten You might want to create a condition So let's say if it's greater than ten And they go to the number then you might want to obviously format this one to be something like I don't know Is blue that could be a suggestion to you to obviously pick out those ones if you so desired But we only want these ones here So we're gonna do okay, and you can see all of our field backgrounds have now changed as we require So and the best part of this is obviously it's all dynamic So should these numbers change then so will the formatting that is overlaid to them as well So hopefully that wasn't too long that video trying to keep these nice and short But a good introduction on obviously how to use power bi in terms of conditional formatting So there'll be a few more videos coming out shortly that are touching on similar topics to this one as we Briefly breezed over earlier in this video So make sure you subscribe to the channel so you get notified when those videos become available And also as a big favour to myself if you could and you enjoyed this video Please make sure they hit that like button because not only does it show me the content You'd like to see more of but it helps are all important YouTube algorithm as well So thank you very much for watching and we'll see you in the next video