In Power BI, you can use complete report as the Q&A suggestion. I mean, you can display a complete report with filters under the Q&A suggestions list. In this article, we will show you, How to use these Power BI Q&A Advanced options with practical example.
For this demonstration, we are using Second Dashboard.
Power BI Q&A Advanced
In this example, we are using the Sales Report present in Basic Reports in RPT1. I suggest you to refer, Page Level Filters to understand this report, and Publish 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 will open the following window. Let me click the Edit report button
Next, we added Country to Page Level Filter. I suggest you to refer Page Level Filter article.
We selected Require Single Selection, and then selected 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 sales report, it is ask for the country name. Let me select Australia.
You can see that it is display the complete report filtered by Australia.
Let me try for Germany