PowerBI

A dataset that includes _ can be used to create a map visualization.

A. house numbers, street names

B. geospatial data

C. city names, country names

D. longitude, latitude

• A, B, C, D

• A, C, D

• B, C, D

• D

How do you create a chart visual in Power BI Desktop Report view?

A. Click New Visual on the Home tab.

B. Select a chart visual in the Visualizations pane.

C. Click New Visual on the Data Tools tab.

D. Select a field that contains values.

• A, B, or D

• B or D

• B orC

• A or B

What daily sales number does this DAX measure formula calculate?

CALCULATE(SUM([Sales]) ,DATESMTD([Date] ))

• running total sales in each month that starts over each month

• total sales for the entire month

• running total in entire year for the entire month

• rolling average over 12 months of sales

You are creating a report in Power BI Desktop and want to restrict the data to records where Country="Canada". To accomplish this, what do you need to create?

• a directive

• a custom column

• an indexed column

• a parameter

. What is the primary benefit of using visualizations such as line charts, bar charts, and column charts?

• They are easier to create than other visualizations.

• They require fewer resources than more complex visualizations.

• They are also used in Excel, so they feel familiar to users.

In Power BI service, deleted pages are available after deletion until

• midnight of the day on which they are deleted

• you empty the Recycle Bin

• the report has been saved

You need to add a required color to a bar chart. How can you add an exact color value to an existing bar chart?

• Click the color in the visual (e.g., the bars) and right-click to select the color.

• You cannot select custom colors in a bar chart or related visual.

• Select the value closest to this color from the color formatting options

The Excel function IF is nearly the same as which DAX function?

• SWITCH

• IFS

• IFX

Power BI’s Publish to Web option allows you to embed visualizations within_. (Select all that apply.)

A. blog posts B. email messages C. web sites D. text messages

• A, B, C

• A, C, D

• A, B, C, D

What can you do within the Power BI Desktop ## Query Settings pane?

A. Rename a query step.

B. Delete a query step.

C. Delete from one query step to the end.

D. Reorder the steps.

• A, D

• A, B, C, D

• A, C, D

• B, C, D