From the course: Power BI Essential Training

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Tweak your dataset for Q&A

Tweak your dataset for Q&A - Power BI Tutorial

From the course: Power BI Essential Training

Start my 1-month free trial Buy for my team

Tweak your dataset for Q&A

“

- [Instructor] Earlier in this course, we were working with dashboards, and we use Q&A in a dashboard. And I also showed you how we could use the Q&A visualization in a report. I want to show you how we use Power BI Desktop to modify a semantic model so that it better supports the use of Q&A, whether that is in a report or in a dashboard. So I'm going to close this data model, we're all done with it, and I'm going to fire up Power BI desktop again, choose Get Data, Excel Workbook, Connect. And in Chapter 07, Original_Catalog_Requests.xlsx, which we have seen previously. We're going to connect. I'm going to choose Table1. Looks good, load it. Now, there's a Transform Data button we just saw before the load, and if you wish, you could do your transformation before loading data. Up to you. So here's our table. And we don't even have to go into Power Query to make some of the changes we're going to make here. And every change I'm going to show you, except for synonyms, we could make in…

Contents