In Power BI, you can use the complete report as the Q&A suggestion. I mean, you can display a complete report with filters under the Q&A suggestions list. Let me show you how to use these Power BI Q&A Advanced options with a practical example. For this Power BI Q&A Advanced demonstration, we are using Second Dashboard.
TIP: I suggest you refer the Q&A Introduction article to under the introduction part and Customize Q&A suggestions article to add your own set of Power BI questions.
Power BI Q&A Advanced
In this example, we are using the Sales Report present in Basic Reports in RPT1. I suggest you refer to Page Level Filters to understand this report and Publish a report from Desktop to understand the Dataset.
Please go to My Workspace -> Reports tab and then click on the Basic Reports in RPT1. Clicking this opens the following window. Let me click the Edit report button
Next, we added Country to Page Level Filter.
We selected Require Single Selection, and then selected the United States as the Default value.
Next, go to the Page Settings tab, and add your questions inside the page information. As you can see, we added three terms. It means when I type Sales report, revenue report, or products report (any of these three terms), it will call this report
Let me go to the Second dashboard Q&A window.
When I type the sales report, it is asking for the country name. Let me select Australia.
You can see that it displays the complete report filtered by Australia.
Let me try for Germany
Comments are closed.