Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I want to create a multi layer Sanky chart for Sales Pipeline Analysis of Salesforce Data.
I want a Visual to be look like -
Requirement Description-
My Data Model Looks Like --
The table That need to be used for the sanky would be Opportunity Snapshot because Opportunity Snapshot contains the following columns -
The Pipeline Start Date
Opportunity Stages - Closed Won, CLosed Loss ( Pushed is not Present in the Stage right now )
Incremental ACV
Last two pillars Push (Yellow Color) and Push(Orange color) are not present in any column of Snapshot table.
Now can anyone suggest the structure of Sanky table . It will help me to do transformation.
Thanks
Solved! Go to Solution.
Your data rows need to contain "From" and "To" columns. You need to prepare these values outside of Power BI. Usually you would use the Opportunity Field History object data from Salesforce.com directly. It has these fields.
Once that is in place you can use the normal Sankey visual.
Your data rows need to contain "From" and "To" columns. You need to prepare these values outside of Power BI. Usually you would use the Opportunity Field History object data from Salesforce.com directly. It has these fields.
Once that is in place you can use the normal Sankey visual.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.