Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

SWITCH

Hey guys, 
I am basically using simple Switch measure with created external table and only using this switch function in my x axis on the graph. Now I want it to respond to the filter, but every time I filter one value, the top two just dissapear. Any ideas how to work around this ? I only need to filter the date and that measures such as the first one only sums, but the it just dissapears with the selected value. 

 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Its not the thing that I want to switch measures using slicers, its just I want it to show the values if the date selected. 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Literally after just selecting one particular date, I get this: 

    But as you can see from the measure, there should be two more measures here .