Question 81
You manage a Power BI model has a table named Sales and product.
You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?
You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.
What should you do from Power BI Desktop?
Question 82
You have a Power Bl workspace that contains a dataset. a report, and a dashboard. The following groups have access:
* External users can access the dashboard.
* Managers can access the dashboard and a manager-specific report.
* Employees can access the dashboard and a row-level security (RLS) constrained report.
You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised.
What should you use?
* External users can access the dashboard.
* Managers can access the dashboard and a manager-specific report.
* Employees can access the dashboard and a row-level security (RLS) constrained report.
You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised.
What should you use?
Question 83
Which DAX expression should you use to get the ending balances in the balance sheet reports?
Question 84
You need to create a relationship in the dataset for RLS.
What should you do? To answer select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

What should you do? To answer select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 85
You have a Power BI report that contains one page. The page contains two line charts and one bar chart.
You need to ensure that users can perform the following tasks for all three visuals:
Switch the measures used in the visuals.
Change the visualization type.
Add a legend.
The solution must minimize development effort.
What should you do?
You need to ensure that users can perform the following tasks for all three visuals:
Switch the measures used in the visuals.
Change the visualization type.
Add a legend.
The solution must minimize development effort.
What should you do?
