Multi-Level Sankey Chart in Power BI using DAX Technique | Data from Web, The Richest in 2020 Forbes

Подписаться 50 тыс.

Просмотров 11 тыс.

50% 1

Multi-Level Sankey Chart in Power BI using DAX Technique | Data from Web, The Richest in 2020 Forbes. #Sankey #POWERBI #DAX #ExcelBasement #Forbes #Microsoft365
DAX is given below:
Table =
UNION(
SUMMARIZE(
SELECTCOLUMNS(Sankey,"Source",Sankey[Country],"Target",Sankey[Industries]),
[Source],
[Target],
"occurs", COUNT(Sankey[Net worth $B]),
"Net Worth $B", SUM(Sankey[Net worth $B])
),
SUMMARIZE(
SELECTCOLUMNS(Sankey,"Source",Sankey[Industries],"Target",Sankey[Organization]),
[Source],
[Target],
"occurs", COUNT(Sankey[Net worth $B]),
"Net Worth $B", SUM(Sankey[Net worth $B])
)
)

Опубликовано:

7 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 11

@sayyedgulzaib9877 3 года назад

Thanks for this. Clear and crisp instructions.

@samashrudhari3416 3 года назад

Thanks for the tutorial. Could you help me how to add more information on Weight, such as Net Worth and Rank at the same time, and with its unit (Billions). So it can be shown in the tooltip as well.

@andy97211 3 года назад

Thanks for this Rahim. It was very helpful!

@ExcelBasement 3 года назад

My pleasure 😊

@andy97211 3 года назад

@@ExcelBasement I did have a follow up question. I used your method and it worked perfectly. However, I'm trying to add other visuals to tell more of the story (eg. a table with more qualitative information that reacts to what I click within the sankey). The data is in the original table. But because a multi-level sankey requires the creation of a new table, I lose the link to the rest of the original data table. Any chance on how to connect the two to create supporting visuals for the sankey?

@bencunningham8871 3 года назад

@@andy97211 Andrew did your [Source] column work to be picked up as a column after specifying it as "Source" earlier.? I get an error saying the argument where [Source] is requires a column.

@user-ey9qd2xx1n 7 месяцев назад

Trank you very much!Are more than 3 layers possible? Is it possible to make this interaktive, so that, when I click on one Value, than I can see a table, which ist containing the data of this single connection?

@tobilandsfried8083 9 месяцев назад

How does your Table look like? Mine looks really weird...

@rodneyroche3929 2 года назад

Thank you for your video, can this be used without the sum and count function? I just want to show the flow of data from 1 destination to another from a source. I have 4 destinations that the data travels until it reaches the final destination. How can this be done?

@syedzarar5127 2 года назад

This dax tecnique is really helpful but is there any way to automate this to accommodate for paths which have more than 20/30 source-target combinations? The thing is that my data currently contains a path which is 39 columns long and I may have an instance in the future where this might increase so is there any way to cater for this situation?

@bencunningham8871 3 года назад

The [source] column is not being picked up as a column - any ideas on why this could be?