Using a different weight in the last level of Sankey Chart
Hi Guys I am creating a sankey chart that analyzes the electricity consumption. There are a total of 6 levels in the chart, and the weights used is the sum of consumption data. In the last level I want the data from the previous level to be multiplied by a value that can be changed dynamically by a parameter. This multiplied value is to be used as the weight that connects the 5th level and the 6th level. while I am trying to do this using the below attached code PowerBI automatically picks up the default value assigned and returns the weight in the last level and dynamic setting of the parameter doesnt work. The entire setup works seperately when I use a card to see the working. Can anyone please help me with this issue please. I am using 1 parameter and 3 measures here: 1. StandardConsumption = SUM('Final (Trial)'[Consumption]) 2. SelectedMultiplier = SELECTEDVALUE('Parameter'[Parameter], 1) 3. MultipliedConsumption = SUMX( 'Final (Trial)', 'Final (Trial)'[Consumption] * [SelectedMultiplier] ) This is the Dax I am using to create my sankey chart: SankeyData = UNION( SELECTCOLUMNS( 'Final (Trial)', "Source", 'Final (Trial)'[Year], "Destination", 'Final (Trial)'[Month], "Year", 'Final (Trial)'[Year], "Month", 'Final (Trial)'[Month], "Consumption", [StandardConsumption] // Standard Consumption ), SELECTCOLUMNS( 'Final (Trial)', "Source", 'Final (Trial)'[Month], "Destination", 'Final (Trial)'[Meter], "Year", 'Final (Trial)'[Year], "Month", 'Final (Trial)'[Month], "Consumption", [StandardConsumption] ), SELECTCOLUMNS( 'Final (Trial)', "Source", 'Final (Trial)'[Meter], "Destination", 'Final (Trial)'[Sub_Station], "Year", 'Final (Trial)'[Year], "Month", 'Final (Trial)'[Month], "Consumption", [StandardConsumption] // Standard Consumption ), SELECTCOLUMNS( 'Final (Trial)', "Source", 'Final (Trial)'[Sub_Station], "Destination", 'Final (Trial)'[Division], "Year", 'Final (Trial)'[Year], "Month", 'Final (Trial)'[Month], "Consumption", [StandardConsumption] ), SELECTCOLUMNS( 'Final (Trial)', "Source", 'Final (Trial)'[Division], "Destination", LOOKUPVALUE('eMI'[Emission], 'eMI'[Division], 'Final (Trial)'[Division]), "Year", 'Final (Trial)'[Year], "Month", 'Final (Trial)'[Month], "Consumption", [MultipliedConsumption] ) )
How I can sort links in Sankey diagram to clean the chart?
Hi, I am using custom visual that is Sankey Diagram by ChartExpo. Chart is created successfully, but I want to sort the links to make the chart clean. Please guide is there any way or property to sort the incoming and outgoing links? Chart is hsown as below: TIA
It is possible to use Sankey Chart custom visual in Power BI Report Server?
I am trying to see sankey chart custom visual in Power BI report created with Power Bi Desktop Report Server, but the following message appears: Can't display this visual. To see this custom visual, add it to this report first: sankey02300D1BE6F5427989F3DE31CCA9E0F32020 Please try again later or contact support. If you contact support, please provide these details. Thanks for any help!
