Forum Discussion
Dynamic Chart
Hi All. Just FYI that I got this fixed. I created a scenario table that contains all possible options per material types. Created measures to calculate static columns and measure to show dynamic ones. Thanks!
Community ChampionYou can’t directly overwrite column values in Power BI like in Excel.
👉 Instead, create a measure (with a what-if parameter or scenario table) that recalculates only the selected row, while others stay the same.
Then use this measure in your chart, not the raw column.
That way, your blue row updates dynamically, and the other bars remain fixed.
Thanks for this suggestion Shahid12523 . Now I wonder how this what-if parameter or scenario table will look like? Is it the table that alish_b mentioned above with all the possible scenarios/combinations based on the dropdown values found in the low carbon option selection? I am really interested to see how it will look like and how I can use the measure to replace the low-carbon values instead of the raw column.