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] ) )