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!
Super UserHey 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!