Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

Опции темы Поиск в этой теме Опции просмотра
Старый 02.12.2017, 00:11   #1  
Blog bot is offline
Blog bot
21,321 / 725 (67) +++++++
Регистрация: 28.10.2006
stoneridgesoftware: Creating Hierarchies in Power BI

One of the cool features in Power BI is that it allows you to create your own hierarchies. When a visual has a hierarchy, it enables the ability to drill down for additional relevant details. For example, you might have a visualization that shows the product hierarchy with revenue and you want to drill down on a specific product that is under-performing. By drilling down, you’re able to see the elements that make up the product and pin-point exactly what product or products are causing the decrease in revenue.

In this post we’ll cover how easy it is to create hierarchies in Power BI using the example above.

1) Before we build a hierarchy, we’ll need to know the levels that comprise the hierarchy. In our example, the levels are Category -> Subcategory -> Product -> Product Image URL.

2) After we know the hierarchy levels, we’ll use simple drag/drop techniques to create the hierarchy. Since Category is our first level in the hierarchy, let’s look for Subcategory and place it right on top of Category. Notice that there is a new item was created called “Category Hierarchy.”

3) Finally, we’ll drag and drop Product, and Product Image URL on the Category Hierarchy we just created and rename Category Hierarchy to Product Hierarchy by right-clicking Category Hierarchy and selecting “Rename.”

4) Now that our hierarchy is created, we can see it in action. In the top right-hand corner, we have a bar chart named “Sales Amount by Category” where the drill actions will take place. There are two methods to drill up/down. First, you can right-click on a bar and drill down or you can turn drill down on. By turning drill down on, we’ll be able to drill down on a level by clicking on it rather than doing a right click. My personal preference is to turn drill down on.

5) To turn drill-down on, click on the chart and click on the down arrow in the top right-hand corner of the chart. Once enabled, the down arrow will have a black background.

6) We see that “Arts and Crafts is our lowest performer in terms of sales. To drill down on that item, simply click on it and the chart will immediately go to the next level.

7) To drill back up you can right-click any bar and select “Drill Up” and the report will go back up one level.

Drilling up/down allows us to slice and dice our data to uncover patterns and anomalies. In this short demonstration, we saw how easy it is to create a hierarchy in Power BI and enable drill up/down functionality.

Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
stoneridgesoftware: How to Pull Data from Microsoft Dynamics 365 into Power BI Reports Blog bot DAX Blogs 0 19.07.2017 20:13
stoneridgesoftware: How to Integrate Power BI with Dynamics 365 for Financials Blog bot DAX Blogs 0 01.04.2017 02:17
stoneridgesoftware: Configuring Power BI Integration for Dynamics 365 Workspaces Blog bot DAX Blogs 1 07.03.2017 10:04
stoneridgesoftware: Email Alerts on Power BI Dashboards with Microsoft Flow – Better Together Blog bot DAX Blogs 0 19.01.2017 20:11
stoneridgesoftware: How to Integrate Power BI with Project Madeira Blog bot DAX Blogs 0 09.06.2016 17:11
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Часовой пояс GMT +3, время: 21:25.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.