Join Gini von Courter for an in-depth discussion in this video Ask a question with Power BI Q&A, part of Power BI Pro Essential Training.
- [Voiceover] The dashboard out of the sample, but also the dashboards that we created feature the ability to Ask a question about our data. This is the doorway to Power BI Q and A, which is a very powerful tool, and our final way that we can create tiles for use in dashboards. Notice that we're in the dashboard when we're doing this. To start simply click where it says Ask a question and we're taken to a second page, and notice that there are Customer Catalog Requests in the Catalog Request and it says there's phones, there's IDs, there's request months, request dates, latitude, longitude, and zipcodes.
So I might ask a question, for example, what state, notice that states filled in, has the most requests? Check that out, I get a chart in request order. Now I can say more about this. I can say I'd like this as a table. I can say I would like to see this as a tree chart, a treemap chart, we saw that earlier.
Request by State. Kind of cool. I like this, this works for me. If I wish now I can hang onto this by pinning it. We're gonna Pin this visual to our catalog request dashboard. And again, one more way to create tiles. Right here. I like this, works for me. Let's tweak this just a little bit, because the column name is Cat requests, and maybe that's a good column name or not, we'll take that up in another movie shortly, but I can edit this.
Right here is my pencil and one of the things I can do is I can name this tile Catalog requests by state. Now the by State is already in there in the Subtitle, so I could just say Catalog request. If I'd like to Display the last refresh time I can do that. That's kind of nice. If I want to have a custom link, so that when someone clicks here it will take them somewhere else, perhaps in my intranet or elsewhere, I can do that, but all I wanted to do really was modify the Title so that it's a little more in keeping, rather than Cat_requests.
Let's do it again. Let's ask another question about our data. So here's the question that I just asked and it hangs out there as one of the choices. The other choices were made up by Power BI guessing what we might want to know. So what I'd like to know now is I would like to know requests by month as column chart.
Wow, that's telling me something. That's significant. Maybe I'd like a pie chart instead. Notice how easy it is for me to switch methods. Maybe we'd like to see it as a line chart. Maybe we're not answering the phones in the summer, that's pretty significant. And notice that the choices that are here include my column headings and also values. If, for example, I wanted to look for particular values I could do that.
Like that, if I wanna keep it I can Pin the visual, if I don't, I can simply return, because if I want to ask that question again I can simply return and ask the question. Cat request as map by state. This has a legend I don't want, we could eliminate that. These are actually people's first names.
So that I could choose somebody specific and find them I guess. All of the Amy requests. For you to be efficient with this you'll want to know the names of the columns in your dataset and you'll want to have a good familiarity with the different types of visualizations that you can use to represent your data. And remember, if you like the visual that you created, super easy to pin it, so that it appears on one of your dashboards.
- Signing up for Power BI Pro
- Connecting to data sources
- Uploading data such as CSV and XLS files
- Creating reports, visualizations, charts, and maps
- Filtering, sorting, copying, and pasting visualizations
- Downloading custom visuals from the gallery
- Modifying existing reports
- Creating and managing data dashboards
- Querying data with Power BI Q&A and Microsoft Cortana
- Sharing report and dashboards
- Using Power BI Desktop and mobile apps