We're going to continue to write additional measures for a Power BI data
model and also look at slicers and filters. Keep watching, alright so now we
have our sales measure defined what we're going to do is now go over to the
budget table and define a similar budget measures. We will say, I'm going to
budget table right now, great. I'm going to say new measure zoom in to that and
I'll say budget equals sum and I love how similar the functions are the
function signatures are to excel, that makes it easy to start off it certainly
made it easier for me when I was starting off as an excel user. But of
course as you go deeper you realize how much how rich this language is. If I
haven't mentioned it before this is DAX by the way that's the name of the
formula language. So you have some and I see budget amount right there so I'm
just going to select that hit tab to complete it close the brackets hit enter,
perfect. So that's done and I'm just going to click on it again. So I don't know if
you notice, hopefully this will go away but as I'm defining a measure somehow I
can't change the formatting I have to click away to something else then click
back on the measure and then it's available. So I'm just going to remove the
decimal places make it zero, great right so and I can I can ignore this implicit
measure don't really care about that anymore and budget if you hadn't noticed
earlier, it was only set for one year maybe we'll go back and change that was only
2016. So if I add my budget in here it's not really apples to apples sales is
right now all the years. So what I can do is I can do a few things actually let's
talk about that. So I can go to calendar and I can bring in the year as a slicer.
So I can bring in year and then change it to a slicer. So if you notice here if
you hover over these elements it gives you a little bit of
description of course you see the graphical icon as well. So this one is a
slicer and I can change that to a slicer and notice it lets me select and I know
that this is a only 2016. So now it's apples to apples now showing these sales
for 2016 and budget for 2016. Let's get rid of colors that make sense
springing subcategory maybe, perfect that looks better. So we have, great so
for year 2016. So we're going to talk a lot more about visualization, but for now
let me just say that so you can do this and I'll show you another method which
is, if you click on the page not on any element click on the page then it's easy
to see these ones. You have page level filters and record level filters. Now for
now we only have, might go away, one page here. But you can add additional pages
and you can build out reports and we'll have lots and lots of fun building
reports. So you can either have a filter which applies to just the page you're
working on or you can add a filter to say no no no,any page that I have 1 2 3 4
or whatever you name them 1 shows sales other shows something else marketing
efforts the next one shows returns or customer support. Each step can have its
own data but then you can say I'm going to drag in a filter and it's going to
apply to the complete report. For now, let's just do one so instead of making
it a slicer I can drop it to a base level filter and set it over there. So
notice what happens here once I set it here it's it's actually that's all
that's available to the page. So even the slicer doesn't show anything else
because it's not available to the page. So when would I use one versus the other
when would I use a filter here versus a filter here. Really in my mind the filter
pane here is meant for authors, right and this is when I want the
end-user to be able to toggle themselves, right. So when I want them to be able to
self-serve choose then I will make it a slicer otherwise I'll make it a filter
here. Now this is not a hard and fast rule in fact in the interface and a lot
of scenarios the users can expand the pane expand the filter pane when they're
consuming the report. Let's go back here, so when they're over here in Power BI.
com consuming the report and you had specified a page filter, they can access
it. But it's just harder it's not that discoverable it's a few more mouse
clicks, this one is right in their faces. So that's how I use it, all right so what
we're going to do is we're going to leave it in here 2016 and remove it from
here. Hey, keep watching more videos and keep learning Power BI. But if you did
enjoy this video I would love to hear from you. So leave a comment, like,
subscribe, all the good stuff. Power on my friends.