Hierarchies In Power BI Visualizations - Problem Of The Week #8 (Power Query Solution)

preview_player
Показать описание
Working on hierarchies and transforming them into a dynamic visualization inside Power Bi is a very common use case, and this Problem of the Week is inspired by a real-life use case that Alex encountered. In this video, Alex shows how I solved it using Power Query, and hopefully it will help in your report development.

The Problem of the Week initiative is open to members and non-members with the goal to improve Power BI skills through practical application.

***** Video Details *****
00:00 Introduction
00:42 The data set
03:20 Unpivot columns
03:40 Duplicate attribute
04:16 Create an index column
04:36 Create previous level number column
06:11 Add conditional column
07:21 Replacing value of null
07:39 Using GROUPBY
09:10 Hot to do a Merge
11:18 Find the country level
16:52 Adding a shape map

***** Related Links *****

***** Learning Power BI? *****

#EnterpriseDNA #PowerBI #ProblemOfTheWeek #PowerBIDesktop #PowerBITutorial #PowerQuery #PowerQueryTutorial #PowerBI Visualization #DataVisualization #Hierarchies #HierarchiesPowerBI
Рекомендации по теме
Комментарии
Автор

Nice video thx. A while ago i used a similiar approach for hts code levels but this seems more elegant.

utubayisi
Автор

Hi
very useful video and very practical need everyone for every project big thanks to share with us.



If it can possible can you plzz provide us excel data file which you used.

Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

ashishmohan