More SEC Football data modeling in Microsoft Power BI Query Editor

In this tiny tip, I show you more Data Modeling I performed on my US College (American) Football South Eastern Conference (SEC) Microsoft Power BI Report. I show how I incorporate parameters with my data and I create a custom title for my report.

In this tiny tip, I show you more Data Modeling I performed on my US College (American) Football South Eastern Conference (SEC) Microsoft Power BI Report.  I show how I incorporate parameters with my data and I create a custom title for my report.

Creating a Custom Table in the Microsoft Power BI Query Editor

As I continue building a Microsoft Power BI report that will display the stats for the US College (American) Football South Eastern Conference (SEC); I will show you how I created a custom static table of the 14 teams in the SEC.

As I continue building a Microsoft Power BI report that will display the stats for the US College (American) Football South Eastern Conference (SEC);  I will show you how I created a custom static table of the 14 teams in the SEC.

Displaying Images in the Data using Microsoft Power BI

I am building a Microsoft Power BI report that will display the stats for the US College (American) Football South Eastern Conference (SEC). In this video, I will show you have I get team logos from my dataset to display.

I am building a Microsoft Power BI report that will display the stats for the US College (American) Football South Eastern Conference (SEC).  In this video, I will show you have I get team logos from my dataset to display.

There’s Power Apps in my Microsoft Teams

Today, on the first day of the 2020 Virtual Microsoft Ignite, Project Oakdale was highlighted.  What is Project Oakdale.  It is like the old Reese’s Peanut Butter Cup commercial….  “There is a Power App in my Teams” or There’s Teams on my Power App.”  Whichever way you say it, it ROCKS!  In this video, I will show you the creation of a Power App, using a table that I’ll create in CDS, publishing it all on a Microsoft Teams Channel. 

WHAT???? 

That’s right I said it, all in less than 10 minutes!

Creating Data Parameters with Suggested Values in Microsoft Power BI

I have shown you already how to create parameters with SQL Server data in Microsoft Power BI. This time, I am going to show how to use a suggested list, so rather than manually entering data, I can select my parameter from a dropdown list. By the way, if you are a US College (American) football fan, you will be excited about the report that is being built!

I have shown you already how to create parameters with SQL Server data in Microsoft Power BI.  This time, I am going to show how to use a suggested list, so rather than manually entering data, I can select my parameter from a dropdown list.  By the way, if you are a US College (American) football fan, you will be excited about the report that is being built!

Creating data source parameters for SQL Server in Microsoft Power BI

If you want to model data against a development SQL Server environment and deploy against a production SQL Server, in Microsoft Power BI, this video is for you. In this Tiny tip, I will show you how to create a Parameter, edit your data source, export, and import your work.

If you want to model data against a development SQL Server environment and deploy against a production SQL Server, in Microsoft Power BI, this video is for you.  In this Tiny tip, I will show you how to create a Parameter, edit your data source, export, and import your work.

Using Microsoft Power BI Q&A to ask about a specific field in a column

Yesterday I had the pleasure of hanging out with the Microsoft Modern Excel and Power BI user Group. We were talking about Q&A and discovered, together, a method of asking about data based on the value of a specific column. While using the Q&A feature of Microsoft Power BI, I have done things like “Show me the revenue where the state is MN” but I had asked in this method. We were looking at revenue by Customer Age when someone wanted to know if I could call on a range of ages. The answer is yes, and here are the results. Also, check this group out, they are super cool!

Yesterday I had the pleasure of hanging out with the Microsoft Modern Excel and Power BI user Group.  We were talking about Q&A and discovered, together, a method of asking about data based on the value of a specific column.  While using the Q&A feature of Microsoft Power BI, I have done things like “Show me the revenue where the state is MN” but I had asked in this method.  We were looking at revenue by Customer Age when someone wanted to know if I could call on a range of ages.  The answer is yes, and here are the results.  Also, check this group out, they are super cool!

Nashville Modern Excel & Power BI User Group

Nashville, TN
1,123 Excel Users

Welcome to the Nashville Modern Excel & Power BI User Group!We are here to help Nashville’s Excel Users be successful in the age of data.  We meet once a month and the lunch …

Next Meetup

Meyers Briggs Personality Types You Find In A Self-Service …

Thursday, Oct 15, 2020, 11:30 AM
36 Attending

Check out this Meetup Group →

Renaming and Hiding Fields in Microsoft Power BI

Microsoft Power BI allows for the hiding of fields in Report Mode.    In this Tiny Tip video, I will show you how hiding fields affect Q&A and DAX.

Tiny Tips

Microsoft Power BI allows for the hiding of fields in Report Mode.    In this Tiny Tip video, I will show you how hiding fields affect Q&A and DAX.

Today’s DAX Expression:

Customer and Class = 
Customers[Customer Name] & " " & Customers[Customer Class]

Using DAX with Conditional Formatting in Microsoft Power BI

OK, I have this table visual in my Microsoft Power BI Report and I want to highlight a row if a column value is “Yes” but do nothing to the background if the value is “No”.  In this Tiny Tip video, I will show you how to achieve this very thing.

Tiny Tips

OK, I have this table visual in my Microsoft Power BI Report and I want to highlight a row if a column value is “Yes” but do nothing to the background if the value is “No”.  In this Tiny Tip video, I will show you how to achieve this very thing.

Today’s DAX Expression:

Hold Background Color =
VAR _HoldColor = SELECTEDVALUE(Customers[Hold])
RETURN
IF(_HoldColor = “Yes”, “#A0D1FF”)