Power BI Q&A helps you ask business questions or analyze data using natural language. In this case, we show you the uses of Q&A with a practical example. Before we start digging into the Q&A’s, let me show you the existing dashboards in my workspace.
To view the Power BI Q&A, please click on the My Workspace and then go to the dashboards tab. From the screenshot below, see that there are five dashboards.
We use the third Dashboard to demonstrate Power BI Q&A in this example. Please click on it to see the reports on this dashboard.
Power BI Q&A
From the screenshot of Power BI below, you can see the text Ask a question about your data. It is the place where we can write business-related questions in natural or standard language.
Once you click on that area, the following window is shown
- Exit: Use this button to exit from this window. It will redirect you to the previous dashboard.
- Ask a question about your data: You can ask any business or data related question.
- Suggestions: These suggestions are displayed based on the data, or you can Predefine them
Remember, we designed many pages from this dataset. That’s why it is mostly showing those reports. In your case, it might be different. I mean, it may show more words like cities, product sales, etc.
Power BI Q&A Example 1
Let me select the Pie Chart.
From the below screenshot, you can see the Pie Chart that was already present in my report.
Power BI Q&A Example 2
Other than the predefined scenarios, you can ask your own business questions. Remember, the IntelliSense is fast enough to provide suggestions and also shows the visuals that are best suited for the question. As you can observe, when I typed s, it displayed all the possibilities that match S and also drew a table with martial Status S.
Let me select the Sales Amount from Fact Internet Sales
The moment I selected the Sales Amount, it displayed the Total Sales Amount Card.
Let me ask for sales by country.
You can see the Bar Chart displaying the Sales by Country.
TIP: You can use the Pin button on the top right corner to Pin this visual to the Dashboard. And you can use Visualization, Filters, and Fields tabs to customize this visual as per your requirement.
This time sales by color
Question and Answer Example 3
In Power BI Q&A, by clicking the term underlined with yellow color, you can replace it with another field. Let me select Sales and replace it with Total Product Cost.
Now you can see the Bar chart displaying Total product Cost by Color
You can also try to replace the Color term.
Q&A Example 4
This time we use a regular question. I mean, a standard question, and it displays the result.