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

September 11, 2020September 11, 2020 / Belinda Allen / Leave a comment

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!

Renaming and Hiding Fields in Microsoft Power BI

September 4, 2020September 2, 2020 / Belinda Allen / 1 Comment

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 Q&A to assist in User Adoption of Microsoft Power BI

August 28, 2020August 21, 2020 / Belinda Allen / 1 Comment

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

August 26, 2020August 21, 2020 / Belinda Allen / Leave a comment

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

August 24, 2020August 21, 2020 / Belinda Allen / Leave a comment

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!

	Microsoft Power BI S… on Microsoft Power BI Story Telli…
	Parameters for Excel… on Parameters for Excel File Path…
	Frank on Matrix (visual) totals and sub…
	Microsoft Dynamics B… on Microsoft Dynamics Business Ce…
	Show Value for the L… on Show Value for the Last Date i…

Bits and pieces from the world of Business Intelligence by Belinda Allen

You cannot improve what you do not measure.

Q&A

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

Nashville Modern Excel & Power BI User Group

Renaming and Hiding Fields in Microsoft Power BI

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

Creating Suggested Questions in Microsoft Power BI Q&A

Using Synonyms in Microsoft Power BI Q&A