I am creating a dynamic dashboard with charts and dependent dropdowns.
When I change a value in the main column, I need values in 3 other columns with dropdowns to be deleted/cleared automatically - I have tried “Reset on edit”, but it resets for every single edit. Can I reset to blank only when the values in the main column change?
Can I dynamically choose different columns to analyze the data? for example, decide “ColumntoAnalyze” based on a dropdown. The calculations are done on a different column using the formula SUM(SELECT(TableA[ColumntoAnalyze], TRUE)) - [ColumntoAnalyze] this value is determined by the dropdown.
Same as number 2, but dynamically select table to use in the select function. How can I do that?
Thanks in Advance