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