Forum Discussion
Solved
Dynamically update calculated column values with slicer
Hello everyone, I've got the problem with setting up slicer and modifying calculated column What am I trying to achieve - Modify the line chart with slicer's value. How values for the ch...
Hello,
I have solved the issue with the following steps:
(refers to the example formula mentioned in the original post)
1. I have calculated the difference between Val1 and Val2 as seperate column in table;
2. Used 'Values()' to convert it into measurement
3. Corrected original formula to use: Calculate (Divide (), type in {value}*) and created new measure
4. It worked. This was done for each type, and all measures were added to chart separetly.
Although it has some limitations towards visualization, by the end of the day it works. Hopefully it might help someone 🙂
* used for filtering through types
