By Michele Hart
Tuesday, May 2, 2017
Sometimes a single number is the most important thing you want to track in your Power BI dashboard, such as total sales, market share year over year, or total opportunities. You can create a big number tile in a Power BI report or by asking a question in the Q&A box. This article explains how to create one in Q&A.
The question box is the easiest way to make a number tile like this.
At the top of your dashboard, start typing what you want to know about your data in the question box. This example uses the Opportunity Analysis sample.
For example, type "number of opportunities" in the question box.
The question box suggests, restates as Showing opportunity count, and displays the total number.
Select the pin icon in the upper-right corner to add the number tile to the dashboard.
Pin the tile to an existing dashboard or to a new dashboard.
A Success message (near the top right corner) lets you know the visualization was added, as a tile, to your dashboard.
Select Go to dashboard to see the new tile. There, you can rename, resize, add a hyperlink, and reposition the tile, and more on your dashboard.
If you do not see a question box at all, it may be that the dataset owner has not enabled Q&A for this dataset.
In the upper-right corner of Power BI, select the cog icon and choose Settings.
Select datasets and choose the dataset to enable for Q&A.
Expand Q&A and Cortana, select the checkbox for Turn on Q&A for this dataset and choose Apply.