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”)

 

 

Setting Geographic Data Categories in Microsoft Power BI Q&A

Ever use a map visual in Microsoft Power BI, but the locations are not correct?  In this Tiny Tip I will show you how to categorize geographic fields.  For example, we will take the city field and define it as a City.  If you were trying to display information for the city of New York, Texas, you would not want it to display as the state of New York. 

Tiny Tips

Ever use a map visual in Microsoft Power BI, but the locations are not correct?  In this Tiny Tip I will show you how to categorize geographic fields.  For example, we will take the city field and define it as a City.  If you were trying to display information for the city of New York, Texas, you would not want it to display as the state of New York.

Using Q&A to assist in User Adoption of Microsoft Power BI

User adoption of any application is a “Hard road to Hoe”.  Sorry, the southerner in me breaks out every now and then.  In this Tiny Tip video, I’ll show you how to make a Microsoft Power BI report page, that will help end users have control over what they see.

Tiny Tips

User adoption of any application is a “Hard road to Hoe”.  Sorry, the southerner in me breaks out every now and then.  In this Tiny Tip video, I’ll show you how to make a Microsoft Power BI report page, that will help end users have control over what they see.

 

Creating Suggested Questions in Microsoft Power BI Q&A

If you have ever used the Microsoft Power BI Q&A visual, you know it creates “Suggested Questions” for you based on your dataset.  In this Tiny tip, I’ll show you have to create your own list of suggested questions, ones that are relevant to you and your users!

Tiny Tips

If you have ever used the Microsoft Power BI Q&A visual, you know it creates “Suggested Questions” for you based on your dataset.  In this Tiny tip, I’ll show you have to create your own list of suggested questions, ones that are relevant to you and your users!

Using Synonyms in Microsoft Power BI Q&A

The Q&A is a super cool visual in Microsoft Power BI.  In this Tiny Tip I will show you how to add synonyms to your data fields so Q&A can recognize different terms that end users may enter.  For example, what if you call your customers “Guests” or “Clients”?  If you do, this tip is for you! 

The Q&A is a super cool visual in Microsoft Power BI.  In this Tiny Tip I will show you how to add synonyms to your data fields so Q&A can recognize different terms that end users may enter.  For example, what if you call your customers “Guests” or “Clients”?  If you do, this tip is for you!  Tiny Tips

Using a DAX function as a Report Title in Microsoft Power BI

Using the Card Visual as a Report Title and a value can save you space on a Microsoft Power BI Report. In this Tiny Tip I will show you how to make a DAX measure become text for a Report Title. Because it is a visual, it will even be interactive with the remainder of the report!

Using the Card Visual as a Report Title and a value can save you space on a Microsoft Power BI Report.  Tiny Tips In this Tiny Tip I will show you how to make a DAX measure become text for a Report Title.  Because it is a visual, it will even be interactive with the remainder of the report!

Changing Interactions between visuals in Microsoft Power BI

The ability of visuals to interact with each other in Microsoft Power BI is probably one of the most powerful tools for letting your data talk to you, rather than reading the data.  However, sometimes you might need or want to control how the interactions work.  In this Tiny Tip, I will show you how to make changes to your report so interactions filter rather than highlight, or simply just not change a visual at all. 

Tiny TipsThe ability of visuals to interact with each other in Microsoft Power BI is probably one of the most powerful tools for letting your data talk to you, rather than reading the data.  However, sometimes you might need or want to control how the interactions work.  In this Tiny Tip, I will show you how to make changes to your report so interactions filter rather than highlight, or simply just not change a visual at all.