Power BI Q&A helps you to ask business questions, or data analysis using natural language. In this article, we will show you the uses of Power BI Q&A with practical example. Before we start digging into the Q&A’s, let me show you the existing dashboards in my Power BI workspace.
To view them, please click on the Power BI My Workspace, and then go to the dashboards tab. From the below screenshot you can see that, there are five dashboards.
In this example, we will use the third Dashboard to demonstrate Q&A. Please click on it to see the reports on this dashboard.
Power BI Q&A
From the below screenshot you can see a text Ask a question about your data. This is the place where we can write business-related questions in natural or normal language.
Once you click on that area, the following window will be shown
- Exit Q&A : Use this button to exit from this window. This 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 will be displayed based on the data, or you can Predefine them
Remember, we designed so 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 1
Other than the predefined scenarios, you can ask your own business questions. Remember, Power BI intellisense is fast enough to provide the suggestions, and also shows the visuals that are best suited for the question.
From the below screenshot you can see, when I typed s it displays all the possibilities that match S, and also drawn a table with martial Status S.
Let me select the Sales Amount from Fact Internet Sales
The moment I selected the Sales Amount, it is displaying 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 Pin button on the top right corner to Pin this visual to Dashboard. And, you can use Visualization, Filters, and Fields tabs to customize this visual as per your requirement.
Power BI Q&A Example 2
This time sales by color
Power BI Q&A 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 replaced it will 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.
Power BI Q&A Example 4
This time we will use regular question. I mean, normal question
From the below screenshot you can see, it is displaying the result