DEMO: How to Set Up Parameters for POWER BI Reports

Parameters are a fancy term to me for a variable that you can change the value of any time you wish. Parameters on a report allow you to change what data you are actually loading and looking at.

If you set up a parameter on a date column you can filter what dates from your data source actually get loaded.

If you decide to set a parameter on a geographical column like state or city, you get to decide what geographical data actually gets loaded.

If you set a parameter on a data source you get to decide what source you are pulling your data from.

You might be thinking, can’t I just do all of that in the Power Query editor using filters on a column. You are correct in your thinking, but I need you to think beyond the desktop application and think about what happens when you publish out to the service. I need you to think about what your end-user needs to decipher what data they are going to look at.

If I have tickled your interest, in what parameters can do then take a look at my DEMO VIDEO for a basic example of how parameters can help you develop your Power BI reports. Stay tuned for more advanced examples of incorporating parameters.

Comments

The Power of CALCULATE in Power BI

Last week in my blog and video I discussed how Power BI could have made my life as a teacher much easier. It is not that Power BI can do things that I could not on my own. It is the fact that Power BI could have saved me so much time. This led me to some thoughts and questions. How could I have impacted the students more in the classroom with this extra time? Would teachers who were not analyzing student data due to time constraints now start? How can I make the data tell my students a story that gives them an accurate picture of their progress? That last question is what leads to this week’s blog. Many times the metrics (which is just a fancy word for "numbers") of what we want to show are easy to do by hand with a basic math background. Although easy, it can be very time consuming when dealing with different groups of data: like 6 periods of students instead of 1 period. When we want to do these calculations quickl...

The Teacher Becomes the Student

My wife asked how my first day was going so I sent her this selfie. Only a picture could capture it. First, let me tell you that this won’t be your typical Power BI or tech blog that you usually see. Let me set the scene. It was a year and a half ago when I got lucky enough to be introduced to Brian Knight, the CEO of Pragmatic Works over lunch. He had heard from a mutual friend that I was looking to make a career move after teaching Algebra for the past 15 years. Brian started telling me about the company and all the different facets it encompasses. From training, sales, consulting, and app development. Mind you at this time I had never heard of Microsoft Power BI, SQL Server, Microsoft Azure, or have any experience with coding. He told me an opportunity at his company may present itself in the future where I could transfer over my teaching skills into the training side of the above-mentioned programs. I immediately got to work with their On-Demand Learning system to ...

Power Automate: Send Instant Emails From Canvas Apps

In this blog, I want to dive into Power Automate. When I first started with the Power Platform I dove deep into Power BI which then made way for Power Apps. Soon thereafter I was introduced to Power Automate. I sure wish someone had told me about Power Automate when I was a teacher of middle schoolers. There were so many mundane daily and weekly tasks that I could have easily automated if I just would have been exposed to the program. Power Automate is great for taking those routine or repetitive tasks and making them no longer a part of your daily routine. Sure setting up the Power Automate flow takes more time to get created, but once created you then can devote all that extra time you normally would have devoted to the task and now spend them on more mission-critical issues for your job. In this video, I want to show you how you can send an automated email with just a click of a button. Since I learned Power Automate after lea...

The Algebra Teacher Powers to B.I.

Search This Blog