From the course: Power BI Copilot Tips and Troubleshooting
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Solution: Building with Copilot
From the course: Power BI Copilot Tips and Troubleshooting
Solution: Building with Copilot
(upbeat music) - [Instructor] I'll begin with a fresh version of our Power BI model. Let then ask Copilot to create a report page for us. We can use the Copilot input prompt to tell it to create a report page to compare the temperatures, rainfall, and humidity between Santa Barbara and Ontario. Once Copilot returns a result, it automatically adds it to our Power BI model. We see that one issue in this new report page is that it doesn't actually filter down to just the stations of Santa Barbara and Ontario. Instead, we see all the stations in our model. There are a few ways that we can mitigate this issue. For example, we can apply a slicer to our stations in the view. However, this makes the slicer in the user's control to select. While we could create a DAX measure and replace this in our results, let's instead move the Station field to our Filters pane. We'll do so by expanding the Filters pane, and we'll then choose our station to add to the filters on this page. We'll then select…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.