Forum Discussion

LiaR's avatar
LiaR
Frequent Visitor
5 years ago
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...
  • LiaR's avatar
    LiaR
    5 years ago

    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

LiaR's avatar
LiaR
Frequent Visitor
5 years ago

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