Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.
You need to shape the query to display the following three columns:

* Month
* Sales
* Year
'What should you select in Power Query Editor?

You plan to embed multiple visualization in a public website.
Your Power BI infrastructure contains the visualizations configured as shown in the following table.

Which two visualizations can you embed into the website? Each correct answer presents a complete the solution.
NOTE: Each correct selection is worth one point.

You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE; Each correct selection is worth one point.

You have a Power Bl report.
You have the following tables.

You have the following DAX measure.

You publish the dataset to powerbi.com.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.