 In one of our training sessions on reporting and analytics with Power BI, one of the participants asked, how can I format columns separately? So you know that on a table visual in Power BI, it's possible that you'll have a number of columns, maybe 3, 5, 10 columns depending on what you're visualizing on that table. So the participants inquired, is it possible that one of the total values, I don't want it to be shown, I want to hide it, how can I get to do that with in Power BI? When he asked the question, then we felt that, okay, why don't we just make a video on this because this might be a challenge that a couple of people out there, they are experiencing and they will want a solution too. And that's what I'm in front of this video. If you come to my field spin and populate some fields here, so I'm adding my revenue, I want to add my quantity sold, so I'll pull that here, my quantity sold, and then I want to add my discount, so let me see where is my total discount, okay total discount is here, so I'll have that to my visual. Okay, so I have this total discount, okay, so this is what we have. We have our revenue, our region, and then the region is being visualized by revenue, how much did we realize from each of the regions, how much quantity did we sell in each of the regions and what is the discount we realized from each of the regions, so now the question was, what if I want to apply specific formatting to columns, for instance, the person inquired, I don't want to visualize this total discount amount, I want this off, how can I take care of that? The very first thing to do is to note, if I come here to the format pane and I come down to the totals, so you see we have totals here, and I say that it should not show totals, this would take off all the total values and that would not solve the situation. So I'm going to reach on this, but how then do I manage this so that I'm able to just take off a single total and not all the total values? So what I would do instead is to come to just right under the totals, I have specific column and that's where the power is. So specific column allows you access to individual columns within your table, so if I expand on this, now it says apply settings to what? What do you want to apply settings to? Is it the region column or a different column? So I would click on this drop down and I will select total discounts, that's what I want to apply settings to. And now a few other things, what do I want to apply settings to? Is it to the totals or is it to the values or the adders? So I want to apply the settings to the total for now, I'll switch off the adders and now what do I want to do? If we look at this carefully, you will see that we don't have an option to hide the total values here, but what we can do is to come to the text color and then I will just make this a white. Once I turn this to a white, you see that that goes off. The value is still there really. So if I hold on my mouse only, you see it about is still there, but it's not visually represented and that's where you watch. So that's been achieved. It's still there, but we have taken it off. So the same setting is applicable to the matrix visual. So if I turn to the matrix visual now and I add a few data points here, so let me add, I will be adding the revenue so I would add the total discount and probably let me put the profit and I would maybe I'll leave it on this and another thing you may want to do here is to use what we call pre-attentive attributes. So this is something that is pretty much important to understand when it comes to visualization and you really want to pay attention to it. And what it does on a summary level is that it allows you to call your audience's attention to certain part of your visuals or your report. You don't want to be looking at all the numbers. You want to call your attention to specific part of your visual. And so what you want to do is assuming the most important thing in this report is the profit. The profit column is the most important thing. So what you can do is to, so let me use the measure instead. So I'm going to use the measure instead. So what you want to do is that you can come here to specific columns again and say that you want to apply the settings to the total profit. Remember, you select the column you want to apply the certain to and where or how do you want to apply the certain. We don't want to apply it to subtotals. So we do only do want to apply it to the values and what we want is that we want to give it a background field. So I will just click on this and I will select this field for the background. So select this field for the background. That seems to be too dark. So maybe I'm making something like this so that it's pretty light and the essence is just that you want our audience's attention to be called to certain part of the visual, which is the total profit in this case. So essentially is the power of the specific column is that it opens up possibilities to work with certain columns within your visual. So you want to format something differently on your visual. It allows you access to it and it just makes it possible to format that single column rather than altering the entire formatting of all your visuals. I hope you found this helpful. Let's stay tuned and we'll be getting more of this release.