Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

SWITCH(SELECTEDVALUE

Hi, I am using dynamic stacked by. I have created a column which takes user input and I use this value to stack by the 100% stacked bar chart. I have two tables involved here: The prima...
Need Help
Show and Tell
Tips and Tricks
  • AntonioM's avatar
    AntonioM
    4 years ago

    Hi, 

     

    The problem is that the calculated column is calculated at refresh and then remains constant, independent of any filters in the report itself. That means no matter what changes your user makes (including selecting from slicers) the data in that column won't change.

     

    As it ignores slicers, it's giving you the result for if there is no selectedvalue, so always the 'else' part. 

AntonioM's avatar
AntonioM
Solution Sage
4 years ago

Hi, 

 

The problem is that the calculated column is calculated at refresh and then remains constant, independent of any filters in the report itself. That means no matter what changes your user makes (including selecting from slicers) the data in that column won't change.

 

As it ignores slicers, it's giving you the result for if there is no selectedvalue, so always the 'else' part.