Multi-Level Sankey diagram in Power BI using DAX | Sankey Chart Custom Visual

Advantages of Sankey Chart in Power BI:

Flow =
CALCULATE(
SUM('YourDataTable'[FlowColumn]),
USERELATIONSHIP('YourDataTable'[ChildID], 'HierarchyTable'[ChildID])
)

NodeValue =
CALCULATE(
SUM('YourDataTable'[FlowColumn]),
ALL('HierarchyTable'),
'HierarchyTable'[Level] = SELECTEDVALUE('HierarchyTable'[Level])
)

SortOrder =
RANKX(ALL('HierarchyTable'), [NodeValue],, ASC, DENSE)

Effective Flow Representation: Ideal for showcasing the flow of resources, processes, or relationships in a visually compelling manner.

Highlighting Relationships: Excellent for emphasizing relationships and proportions between different stages or entities.

Decision Analysis: Useful for decision analysis, especially when understanding the impact of choices or transitions between stages.

Storytelling: Facilitates storytelling by visually guiding users through a sequence of interconnected events or stages.

Scenario Analysis: Enables scenario analysis by illustrating how changes in one part of the system affect the overall flow.

Data Emphasis: Places a strong emphasis on the magnitude of data flow, allowing users to quickly identify trends and patterns.

Path Analysis: Useful for path analysis, showing the most common or relevant paths within a system.

Process Optimization: Helpful for identifying bottlenecks and optimizing processes by visually assessing the efficiency of flow.

Resource Allocation: Suitable for displaying resource allocation and utilization throughout different stages of a process.

Comparative Analysis: Allows for comparative analysis, showing variations in flow between different categories or time periods.

Impact Assessment: Effective in assessing the impact of changes or interventions within a dynamic system.

Interactive Filtering: Supports interactive filtering, allowing users to focus on specific elements within the chart.

Real-time Monitoring: Can be employed for real-time monitoring of dynamic systems or processes.

Intuitive Design: Once understood, Sankey charts provide an intuitive representation of complex relationships.

Multi-level Hierarchies: Suitable for representing multi-level hierarchies, offering a comprehensive view of interconnected elements.

Visual Appeal: Has a visually appealing design that can capture attention and convey information in an engaging manner.

Enhanced Storytelling: Enhances storytelling capabilities in reports by providing a clear narrative through interconnected stages.

Efficiency Visualization: Efficiently visualizes data flow and relationships without the need for extensive textual descriptions.

Compliance Monitoring: Useful for compliance monitoring, showing how entities or resources adhere to specific stages or criteria.

Predictive Analysis: Can support predictive analysis by illustrating potential future flow patterns based on current trends.

#SankeyChart
#DataVisualization
#PowerBICharts
#VisualAnalytics
#DataFlow
#GraphVisualization
#DataStorytelling
#InteractiveCharts
#InfoViz
#Diagramming
#DataAnalysis
#DataDrivenDecisions
#AnalyticsTools
#BusinessIntelligence
#VisualizeData
#FlowCharts
#DashboardDesign
#BIReporting
#DataScienceVisualizations
#GraphTheory
#InformationDesign
#VisualizationTools
#DataInsights
#ChartDesign
#ExploreData

#PowerBI
#DataVisualization
#BusinessIntelligence
#DataAnalytics
#PowerBIDesktop
#PowerBIPro
#PowerBIService
#DashboardDesign
#PowerQuery
#DAX
#ReportDesign
#PowerBITips
#PowerBISolutions
#BIReporting
#DataInsights
#PowerPivot
#DataModeling
#DataDrivenDecisions
#PowerBICommunity
#PowerBIDashboards
#AnalyticsTools
#PowerBIFunctions
#PowerBIFilter
#PowerBIMobile
#DataStorytelling
#VisualAnalytics
#PowerBIGateway
#PowerBICertification
#PowerBISuccess
#PowerBIJobs
#PowerBIChampion
#DataTransformation
#PowerBIExcel
#PowerBIAggregations
#CustomVisuals
#PowerBIOnline
#PowerBIEmbedded
#PowerBIAdmin
#PowerBIRestAPI
#PowerBIMeasures
#DataIntegration
#ReportDevelopment
#PowerBIRocks
#PowerBIQuery
#PowerBIMapping
#PowerBIMetrics
#PowerBIRollup
#PowerBIBookmarks
#PowerBIQueryEditor
#PowerBIWorkspace
#PowerBICharts
#PowerBIDatasets
#PowerBIDataflows
#PowerBIConnectors
#PowerBIFunctions
#PowerBIAdvanced
#PowerBITransformations
#PowerBISharing
#PowerBIParameters
#PowerBIRibbon
#PowerBIAutomation
#PowerBIAzure
#PowerBIFeedback
#PowerBICustomizations
#PowerBIPieChart
#PowerBIAgile
#PowerBISlicer
#PowerBILearning
#PowerBIEducation
#PowerBIDatasets
#PowerBIHacks
#PowerBIComparison
#PowerBIJSON
#PowerBIMashup
#PowerBITutorial
#PowerBIFilters
#PowerBIProjects
#PowerBIIntegration
#PowerBIForAll
#PowerBIBestPractices
#PowerBIUserGroup
#PowerBIUserCommunity
#PowerBIConsulting
#PowerBICharts
#PowerBICollaboration
#PowerBIMeetup
#PowerBIOnlineTraining
#PowerBIPublishToWeb
#PowerBIProTips
#PowerBIDualAxis
#PowerBIShapes
#PowerBIErrors
#PowerBIMonthlyUpdate
#PowerBIDrillDown
#PowerBIReddit
#PowerBIForFinance
#PowerBIForSales
#PowerBIFinancialAnalysis
#PowerBIForMarketing
#PowerBIArticles

[minikuruvilla]

This is what i have been looking for but i am not able to see the data after transformation. Can you post the file or dataset created after union.

[juliarospendowiski]

Thank you sou much for such clear explanation!

[Abdullah-lysm]

I used the same approach but with large data.The problem is, a target appears twice once as a source with only incoming directions and once as target with outgoing directions. This happened with various targets. Could you please guide in this regard.

[rodneyroche]

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?

[samrusaati]

How to make multiple-choice answers as one line node in the Sankey diagram?

[rgs]

When I search for this video, I understand you have also worked on Tableau it seems and do you have the same video in tableau

[rodneyroche]

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?

[fredatang]

May I ask how to make a Sankey diagram by month? For example, to see the changes in different month.

[bencunningham]

When using the below code I get an error saying selected columns expects a column name in argument number 6. It is not recognising the "Source" as a column - any advice? I also need to take columns from two separate tables is there a way to add >1 table in the first argument of the selectcolumns function?
Snky = UNION(
SUMMARIZE(
SELECTCOLUMNS('MW', "Source", 'MW'[Level 4 (Team) 2], "Target", 'MW'[Level 4 (Team)],
[Source], [Target],
"occurs", COUNT('MW'[_Connections]
),
SUMMARIZE(
SELECTCOLUMNS('MW', "Source", 'MW'[Level 4 (Team) 2], "Target", 'TY'[Level 4 (Team)],
[Source],
[Target],
"occurs", SUM('TY'[Sales])
)
)

[christianlira]

Nice work and thank you for taking the time to produce this video.

[samashrudhari]

How can I add the weight unit (as text) such as currency symbols or metric unit. So it will be shown in the tooltip.
Thank you

[legiegrieve]

Does anybody know how to sort by the source?

[Ram-znpe]

Thank you very much for the video, this helped me a ton!

[pemaincaturindo]

terima kasih contoh nya
dan File latihannya
keren
terima kasih banyak

[Whyandhowly]

Excellent video.. very good example for sankey

[SelfM_]

Hi! Anyone have any experience changing the Json for the lines to be white? We are using a dark theme, so the current setup isn't working that well.

[cy]

is it possible for you to share the PBI file for this