Skip to main content




Power BI Q&A helps you ask business questions or perform natural language data analysis. In this case, we show you the uses of Power BI Q&A with a practical example. Before we dive into the questions and answers, let me show you the existing dashboards in my Power BI workspace.

To see them, click on Power BI My Workspace and then go to the dashboards tab. In the screenshot below, you can see that there are five panels.

power-bi-qa-1-5595912

In this example, we use the third panel to demonstrate the questions and answers. Click on it to view the reports for this dashboard.

power-bi-qa-2-8161404

Power BI questions and answers

In the Power BI screenshot below, you can see some text Ask a question about your data. It is the place where we can write business related questions in natural or standard language.

power-bi-qa-3-4561864

Once you click on that area, the following window will be displayed

  1. Exit questions and answers: Use this button to exit this window. It will redirect you to the previous panel.
  2. Ask a question about your data: You can ask any questions related to the company or the data
  3. Suggestions: These tips are displayed based on the data, or you can predefine them

Remember, we design many pages from this data set. That is why it mainly shows those reports. In your case, it could be different. I mean it can show more words like cities, product sales, etc.

power-bi-qa-4-7605848

Power BI question and answer example 1

Let me select the pie chart

power-bi-qa-5-4332643

In the following screenshot you can see the pie chart that was already present in my report.

power-bi-qa-6-5634292

Power BI question and answer example 1

Apart from the predefined scenarios, you can ask your own business questions. Remember, Power BI intellisense is fast enough to provide suggestions and also displays the visuals that best fit the question.

From the screenshot below, you can see, when I typed s, shows all the possibilities that match S and also draws a table with the martial state S.

power-bi-qa-7-2090446

Let me select the sales amount from Fact Internet Sales

power-bi-qa-8-9011336

The moment I select the sales amount, the total sales amount card is displayed.

power-bi-qa-9-4155246

Let me ask for sales by country

power-bi-qa-10-3270218

You can see the bar chart showing sales by country.

TIP: You can use the Pin button in the upper right corner to Pin this visual to the Dashboard. And you can use the Visualization, Filters, and Fields tabs to customize this visual to your needs.

power-bi-qa-11-3851660

Power BI question and answer example 2

This time sales by color

power-bi-qa-12-7283747

Power BI question and answer example 3

In Power BI Q&A, when you click the yellow underlined term, you can replace it with another field. Let me select Sales and replace it with Total Product Cost

power-bi-qa-13-2456652

Now you can see the bar chart showing the total cost of the product by color

power-bi-qa-14-e1578303605409-1703013

You can also try replacing the term Color.

power-bi-qa-15-7622053

Power BI question and answer example 4

This time we use a regular question. I mean, a standard question

In the below screenshot, you can see what the result shows.

power-bi-qa-16-5577353




Power BI Q&A helps you ask business questions or perform natural language data analysis. In this case, we show you the uses of Power BI Q&A with a practical example. Before we dive into the questions and answers, let me show you the existing dashboards in my Power BI workspace.

To see them, click on Power BI My Workspace and then go to the dashboards tab. In the screenshot below, you can see that there are five panels.

power-bi-qa-1-5595912

In this example, we use the third panel to demonstrate the questions and answers. Click on it to view the reports for this dashboard.

power-bi-qa-2-8161404

Power BI questions and answers

In the Power BI screenshot below, you can see some text Ask a question about your data. It is the place where we can write business related questions in natural or standard language.

power-bi-qa-3-4561864

Once you click on that area, the following window will be displayed

  1. Exit questions and answers: Use this button to exit this window. It will redirect you to the previous panel.
  2. Ask a question about your data: You can ask any questions related to the company or the data
  3. Suggestions: These tips are displayed based on the data, or you can predefine them

Remember, we design many pages from this data set. That is why it mainly shows those reports. In your case, it could be different. I mean it can show more words like cities, product sales, etc.

power-bi-qa-4-7605848

Power BI question and answer example 1

Let me select the pie chart

power-bi-qa-5-4332643

In the following screenshot you can see the pie chart that was already present in my report.

power-bi-qa-6-5634292

Power BI question and answer example 1

Apart from the predefined scenarios, you can ask your own business questions. Remember, Power BI intellisense is fast enough to provide suggestions and also displays the visuals that best fit the question.

From the screenshot below, you can see, when I typed s, shows all the possibilities that match S and also draws a table with the martial state S.

power-bi-qa-7-2090446

Let me select the sales amount from Fact Internet Sales

power-bi-qa-8-9011336

The moment I select the sales amount, the total sales amount card is displayed.

power-bi-qa-9-4155246

Let me ask for sales by country

power-bi-qa-10-2349146

You can see the bar chart showing sales by country.

TIP: You can use the Pin button in the upper right corner to Pin this visual to the Dashboard. And you can use the Visualization, Filters, and Fields tabs to customize this visual to your needs.

power-bi-qa-11-3039310

Power BI question and answer example 2

This time sales by color

power-bi-qa-12-6580494

Power BI question and answer example 3

In Power BI Q&A, when you click the yellow underlined term, you can replace it with another field. Let me select Sales and replace it with Total Product Cost

power-bi-qa-13-1343694

Now you can see the bar chart showing the total cost of the product by color

power-bi-qa-14-e1578303605409-4443411

You can also try replacing the term Color.

power-bi-qa-15-5222784

Power BI question and answer example 4

This time we use a regular question. I mean, a standard question

In the below screenshot, you can see what the result shows.

power-bi-qa-16-1456597
R Marketing Digital