Sometimes the fastest way to get an answer from your data is to ask a question using natural language. In this tutorial we'll look at 2 different ways of creating the same visualization: building it in a report and asking a question with Q&A.
From your Power BI workspace, select Get Data > Samples > Retail Analysis Sample > Connect.
The dashboard contains an area chart tile for "Last Year Sales and This Year Sales." Select this tile.
Open the report in Editing View by selecting Edit Report.
Select the area chart and review the settings in the Fields pane. The report creator built this chart by selecting these 3 values (Time > FiscalMonth, Sales > This Year Sales, Sales >Last Year Sales >Value) and organizing them in the Axis and Values wells.
How would we go about creating this same line chart using Q&A?
Navigate back to your the Retail Analysis Sample dashboard.
Using natural language, type something like this into the question box:
what were this year sales and last year sales by month as area chart
As you type your question, Q&A picks the best visualization to display your answer; and the visualization changes dynamically as you modify the question. Also, Q&A helps you format your question with suggestions, auto-complete, and spelling corrections.
When you finish typing your question, the result is the exact same chart that we saw in the report. But creating it this way was much faster!
Similar to working with reports, within Q&A you have access to the Visualizations, Filters and Fields panes. Open these panes to further explore and modify your visual.
To pin the chart to your dashboard, select the pin icon .
More questions? Try the Power BI Community