Question

In the main Power BI Desktop window, which views can be used to create a new dimensional hierarchy?

1.Both Report and Data Views

2.Relationships View

3.Report View

4.Data View

Answer 1

Answer:

Answer is

3. Report view

Answer 2

Answer:

The correct answer is 1. Both Report and Data Views.

Explanation:

From the above question,

In Power BI Desktop, both the Report view and the Data view can be used to create a new dimensional hierarchy. In the Report view, you can create a hierarchy by adding fields to a table or matrix visual and grouping related data together. In the Data view, you can create a hierarchy by selecting the fields you want to include and grouping them together. The Relationships view is used to manage relationships between tables in your data model, but it is not used to create dimensional hierarchies directly.

In Power BI Desktop, there are several views that can be used to create a new dimensional hierarchy, including:

• Report view: The report view is the main canvas for designing reports in Power BI Desktop. In this view, you can create a new dimensional hierarchy by adding fields to a table or matrix visual. You can then use the fields to create a hierarchy by grouping related data together.

• Fields view: The Fields view is where you can see all of the columns in your data source and manipulate them as necessary. In this view, you can create a new dimensional hierarchy by selecting the fields you want to include in the hierarchy and dragging them onto the Fields well.

• Data view: The Data view provides a view of your data as a table, and allows you to manipulate the data in various ways. In this view, you can create a new dimensional hierarchy by selecting the fields you want to include in the hierarchy and grouping them together.

• Model view: The Model view provides a view of your data at a high level, and allows you to manage the relationships and calculations in your data. In this view, you can create a new dimensional hierarchy by creating a new table and defining relationships between the tables in your model.

These are the main views that can be used to create a new dimensional hierarchy in Power BI Desktop. By using these views, you can create meaningful relationships between your data and organize it in a way that is useful for your reporting needs.

For more such related questions : https://brainly.in/question/49705054

#SPJ3