This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
How do you get Power BI Desktop to find relationships in data after it has been imported?
Open the Power Query Editor
Select Manage Relationships and then Autodetect
Select the New Parameter button to map the relationship
Use the Performance Manager
If your months were sorted alphabetically, how could you sort them by month order?
Click the Edit Queries button
Add a slicer to your visual
Change the visualization type
Apply the MonthNo category sort option
How do you get Power BI to separate date data into year, quarter, month, and day?
Open the Query Editor
Select the New Parameter button
Select the New Measure button
You don't need to do anything, it is automatic.
How do you create data tables that you want stored as part of the model rather than as part of a query?
Use a calculated table
Select the Enter Data button
Why would a table show the same value, like "Sales", for every country?
Because the Revenue data is corrupted
Because the column is assigned with the wrong data type
Because there is no relationship between the Sales and Country fields.
Because the column is sorted incorrectly
You must answer all questions before checking your work.
Continue
Was this page helpful?