You are creating a dashboard by using the Power Bl 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?

• A.Edit the dashboard theme and pin each chart as a file.
• B.Edit interactions in the report and set all interactions to Filter
• C.Pin the report page as a live page.
• D.Pin each chart as a tile.

Comment: *

Name: *

Email: *

Verification: *

You have a Power BI model that contains the following data.

The Date table relates to the Sales table by using the Date columns.
You need to create a calculated table that v/ill contain the following:

Correct Answer:

Explanation:

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Color scale
• B.Rules
• C.Field value

Correct Answer: B

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

Comment: *

Name: *

Email: *

Verification: *

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.
You need to create a relationship between the tables. The solution must ensure that bidirectional cross- filtering honors the RLS settings.
What should you do?

• A.Create an active relationship between the tables and select Assume referential integrity.
• B.Create an inactive relationship between the tables and select Assume referential integrity.
• C.Create an inactive relationship between the tables and select Apply security filter in both directions.
• D.Create an active relationship between the tables and select Apply security filter in both directions.

Correct Answer: D

By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable bi-directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox.
Select this option when you've also implemented dynamic row-level security at the server level, where row- level security is based on username or login ID.

Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

Comment: *

Name: *

Email: *

Verification: *

You import a Power Bl dataset that contains the following tables:
- Date
- Product
- Product Inventory
The Product inventory table contains 25 million rows. A sample of the data is shown in the following table.

The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the ProductKey column.
You need to reduce the size of the data model without losing information. What should you do?

• A.Change Summarization for DateKey to Don't Summarize.
• B.Change the data type of UnitCost to Integer.
• C.Remove the relationship between Date and Product Inventory.
• D.Remove MovementDate.

Comment: *

Name: *

Email: *

Verification: *