QUESTION: 121 Exam Topic: Question Set 3

You have a report that includes a card visualization.
You need to apply the following conditional formatting to the card while minimizing design effort:
-For values that are greater than or equal to 100, the font of the data label must be dark red.
-For values that are less than 100, the font of the data label must be dark gray.

Which type of format should you use?

Color scale
Rules
Field value

Answer(s): B

Explanation:

Finding the conditional formatting in the card visual is a bit tricky. There is no separate option for that. You need to go to the Format tab of the visual, and then expand the Data Label. The right beside the Data Label's colour you need to hover your mouse, and you will find a three dots icon appearing, which if you click on it, you will see Conditional Formatting.

Now in the Conditional Formatting tab, you can apply it in different methods. for example, you can choose Rules, and then

The Rules mode will give you the ability to put custom roles as below;

Reference:

https://radacad.com/enhance-the-card-visual-in-power-bi-with-conditional-formatting

Reveal Solution Next Question

QUESTION: 122 Exam Topic: Question Set 3

DRAG DROP (Drag and Drop is not supported)
You have a Power BI dashboard named DashboardA that contains a tile named TileA. TileA contains a treemap visual from a report named ReportA.
You need to provide the users of DashboardA with additional tiles that relate to the contents of TileA.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

See Explanation section for answer.

Answer(s): A

Explanation:

Step 1: From ReportA, select Get Insights
Then select 'Get Insights'ג€¦ From the Datasets + dataflows tab, select More options (...) next to the dataset, and then choose Get insights.
Power BI Quick Insights will now scan the data related to the tile and display a list of potential insights you may want to explore further. To drill into a specific data point, you can even select data in the visual and Quick Insights will focus on that data point when searching for insights.

Power BI uses various algorithms to search for trends in your dataset.

Within seconds, your insights are ready. Select View insights to display visualizations.

The visualizations display in a special Quick Insights canvas with up to 32 separate insight cards. Each card has a chart or graph plus a short description.
Step 2: From DashboardA, select the TileA options, and then select View Insights
The insight screen opens in Focus mode.
Step 3: From Focus mode, pin the relevant visuals to DashboardA
Go to 'in focus mode' on a dashboard tile for data loaded into Power BI.

Reference:

https://docs.microsoft.com/en-us/power-bi/create-reports/service-insights

Reveal Solution Next Question

QUESTION: 123 Exam Topic: Question Set 3

You are creating a dashboard by using the Power BI service.
You have an existing report page that contains three charts.
You need to add the charts to the dashboard while maintaining the interactivity between the charts.
What should you do?

Edit interactions in the report and set all interactions to Filter.
Pin each chart as a tile.
Edit the dashboard theme and pin each chart as a tile.
Pin the report page as a live tile.

Answer(s): D

Explanation:

One way to add a new dashboard tile is by pinning an entire report page. This is an easy way to pin more than one visualization at a time. Also, when you pin an entire page, the tiles are live; you can interact with them right there on the dashboard. And changes you make to any of the visualizations back in the report editor, like adding a filter or changing the fields used in the chart, are reflected in the dashboard tile as well.
Pinning live tiles from reports to dashboards is only available in Power BI service (app.powerbi.com).

Reference:

https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-live-tile-from-report

Reveal Solution Next Question

QUESTION: 124 Exam Topic: Question Set 3

HOTSPOT (Drag and Drop is not supported)
You need to create a visual as shown in the following exhibit.

The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: Background color
To apply conditional formatting, select a Table or Matrix visualization in Power BI Desktop. In the Visualizations pane, right-click or select the down-arrow next to the field in the Values well that you want to format. Select Conditional formatting, and then select the type of formatting to apply.

Box 2: Rules
To format cell background or font color by rules, in the Format by field of the Background color or Font color dialog box, select Rules.