Power BI Dashboards: Two Features That Answer Questions
Here is a scene I have watched play out in a hundred classrooms. Somebody builds a beautiful report, publishes it, and within a week their inbox is full of questions the report already answers. “Can you filter this to the Northeast?” “What were the numbers for last quarter?” “Is that up or down?” The dashboard is fine. The problem is that nobody wants to click around in it, so they click on you instead. That is the real cost of most Power BI dashboards — not the build time, the answering time afterward.
You can fix a big chunk of that without writing a line of DAX. Power BI ships with two features that most people scroll right past in the Visualizations pane, and both do the same thing: they let the report do the talking instead of you. Here are the two I would set up first — ten minutes each.
Let people ask your Power BI dashboards questions with the Q&A visual
The Q&A visual puts a search box directly on your report page. A user types a plain-English question, and Power BI builds the chart to answer it, live, on the spot.
To add it: on the Insert ribbon, click Q&A — or pick the Q&A icon in the Visualizations pane. Give it room, because the answer renders inside that same box.
Now type questions the way a real person would:
total sales by regionsales this year vs last year by monthtop 10 customers by revenue as a bar chartaverage order value by salesperson in 2026
Notice that last piece — as a bar chart. Name the visual type at the end of the question and Power BI will honor it: as a table, as a line chart, as a map, as a card. That trick alone stops most of the “it gave me the wrong picture” complaints.
Here is the part almost everyone skips, and it is the difference between Q&A that impresses people and Q&A that embarrasses you. Go to Modeling > Q&A setup. Under Field synonyms, add the words your company actually uses. If your column is named Cust_Nm but the sales team says “client,” add “client” and “customer” as synonyms. Under Review questions, you can see every question users have typed that Power BI could not answer — that list is gold, because it tells you exactly what your model is missing.
The gotcha: Q&A is only as good as your field names, and it will not answer anything time-related properly unless you have a real date table marked as a date table (Table tools > Mark as date table). Without that, “last quarter” and “year over year” quietly return nothing useful. Fix the date table first, then add Q&A. Doing it the other way around is how people conclude the feature “doesn’t work.”
Make the report explain itself with Smart Narrative
Smart Narrative writes a paragraph of plain English about what is on the page — biggest contributor, direction of the trend, percentage change — and rewrites itself every time somebody moves a slicer.
Add it from the Visualizations pane; the icon looks like a small paragraph of text. Drop it on the page and it generates a summary of the visuals around it. You can also right-click a single visual and choose Summarize for a narrative about just that chart.
The generated text is editable, and this is where it gets useful. Click into it and type your own sentence, then use the + Value button to insert a live figure into your own wording. So instead of the generic default, you can write something like: “Northeast closed the month at [Total Sales], which is [Sales YoY %] against last August.” Those bracketed values stay dynamic. Your commentary stays yours, and the numbers never go stale.
This is the thing to put at the top of a report that gets emailed to executives. They read one paragraph and know whether they need to look further.
The gotcha: Smart Narrative describes what it sees, not what matters. If one week has an outlier because of a data-load problem, the narrative will confidently announce a “significant increase.” It has no idea your ETL hiccuped. Read the generated sentence before you publish, delete the parts that are just noise, and keep the two or three that a human would actually say out loud. Treat it as a first draft, not a finished statement.
Plenty more on the calendar
If you want to see both of these built from scratch on a live model — plus the newer AI features layered on top, like generating visuals from a description and using Copilot to explain a report page — I am running AI-Powered Dashboards with Power BI on Tuesday, August 25. We cover Q&A setup and synonyms, Smart Narrative, and how to design a page so the AI features have something sensible to work with.
The full current schedule is on the front page of PCWebinars.com, with new dates going up as they are confirmed. Register for this one, or browse the others and find the session that fits what you are wrestling with right now.
About your trainer
I’m Tom Fragale. I have been a computer trainer and consultant for more than 30 years, and I have taught well over 30,000 people how to get more out of the software they already own — Excel, Access, Power BI, Word, Outlook, and now the AI tools that sit on top of all of it: Claude, ChatGPT, and Microsoft Copilot. My background is applied, not theoretical. Alongside teaching, I build real databases and reporting systems for clients in Excel, Access, and Power BI, so the examples I use in class are the problems I ran into last week, not textbook exercises. I also publish free tutorials on YouTube and longer courses online.
You can find the full schedule, along with recordings and other training resources, at PCWebinars.com.
