You are creating a Power BI model that contains a table named Store. Store contains the following fields.
 
You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City.
What should you do to ensure that the locations are mapped properly?

A. Change the data type of City, State/Province, and Country.

B. Set Summarization for City, State/Province, and Country to Don't summarize.

C. Set the data category of City, State/Province, and Country.

D. Create a calculated column that concatenates the values in City, State/Province, and Country.








 

Suggested Answer: C

A hierarchy is a set of fields categorized in a hierarchical way that one level is the parent of another level. Values of the parent level can be drilled down to the lower level.
Create Hierarchy -
Right-click on the field you want to set as level 1 of the hierarchy in the fields list, and then select Create Hierarchy.
 
After that, you will see a new hierarchy created named your field name ג€Categoryג€ plus the word ג€Hierarchyג€. This would have a hierarchy icon beside it and also an option to expand to the fields of the hierarchy. If you expand, you will see a copy of the Category field in there too.
 
Etc.
Reference: alt="Reference Image" />
After that, you will see a new hierarchy created named your field name ג€Categoryג€ plus the word ג€Hierarchyג€. This would have a hierarchy icon beside it and also an option to expand to the fields of the hierarchy. If you expand, you will see a copy of the Category field in there too.
 https://radacad.com/what-a-power-bi-hierarchy-is-and-how-to-use-it

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







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.