Dynamic Chart

[PaulGee]

Hi - first time here and hoping to get some help. 🙂

I have a table where column dynamically changes value of another column and should show in the bar(chart) as well.  How can this be done in PowerBI?  In this example, row in blue changes the value of green column and should show the changes in the chart, where the column bar(blue) changes, but the 2 others stay the same.  It works in Excel, but not sure how to do it in PBI.

[PaulGee · Accepted solution]

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!

[alish_b]

Hey @PaulGee ,

Welcome to the community!

While the requirements are a little unclear, here are my assumptions about your requirement. The table in the screenshot stores distinct or non-repeating types of material in Material Type field. You then have set up data validation in Low Carbon option (Please select) field which allows for selection. Then based on this selection and other rules, you compute the Low Carbon option Total Emissions which is tied to the values in the column chart visual.
If these assumptions are correct, then you are fundamentally updating the base data which is something Power BI, with its read only nature, will not allow you to do (at least not in a straighforward manner). There are a few things that only Excel can do out-of-the-box. The easiest option would be to update the values in Excel and hit refresh in Power BI to see the change. Or, you could try and build a scenario table with all possible combinations but I am not sure if I can recommend this without having a complete grasp of the scope of your requirement. Then there is Power Apps that you could explore, which should be capable of doing what you are looking for but that comes with a learning curve in itself.

Hope it helps!

[PaulGee]

Thank you @alish_b .  I built the scenario table below.  Hope you can take a look at it and guide on how I can replicate it in PowerBI.

[Shahid12523]

You 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.

[PaulGee]

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.