HOTSPOT - 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:

Questions › Category: PL-300 › HOTSPOT – 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:

0 Vote Up Vote Down

Admin Staff asked 7 months ago

HOTSPOT -
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:
 
















 

Suggested Answer: 
    

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.
 
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

This question is in PL-300 Exam
For getting Microsoft Power BI Data Analyst Associate Certificate