Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.